Change the data source of some pivot tables which are with the same data source

Hi Lil13500 

you have to change it one by one for every pivot table. I cannot think of a functionality to do it simultaneously for all pivot tables.