Hi.

I modified the below macro which I found researching online to dynamically update multiple source data and the associated pivot tables but with my limited knowledge I was unsuccessful.
The code works but only updates the last Data_sht and Pivot_sht and it associated PivotName which is "PYQTDPVT" in the code below. However I want the macro to update all the data sources and pivots all at once.
Below is the code I tried to unsuccesfully edit;

Please Login or Register  to view this content.
I appreciate the help

Pi