Hi XlapatsaS,

You can try setting your pivots up by creating the first one, copying it & pasting to the next worksheet & so on.

Test this by making a pivot table, copy it & paste it somewhere next to the original pivot table on the same worksheet & try making a change to the source data such as removing a few Rows of data.

Now go to the original pivot & refresh it, you should see the second Pivot table also refreshes.

Otherwise, you can write a Macro based on the Pivot Table number & tell it to refresh the Pivots.