AutoRefresh 5-7 Pivots within a Workbook. Is it possible?

I’m back again! After Grand success of my first post. All thanks to OllieB. I’m pretty excited to be a part of this Forum…

From my Research, I was able to find the attached Macro that Auto Refreshes Data. I have a request to be able to customize this or have an alternative solution and was hoping to get some expert help….

Here’s my scenario:

I have to create 25 reports daily with 5-7 separate Pivot tabs. The entire data per report for each of the Pivots is pulled in from dedicated tab within each report.

Have also attached a dummy data. Would really appreciate if anyone can help me with a direction on how this can be done and if it is possible? I need to draw Pivots using several columns and combinations.

I understand that the pivots can be refreshed but my problem is that the percentages (example in Column D of the Pivot 1 tab) of the attached gets affected each time I refresh the pivots after changing data. The main thing that I need in those pivots is the flexibility to use the sub-totals to calculate percentage by pivots.

Hopefully, someone can help me out solve this challenge!

Thank you!