I set up a dynamic formula as noted on the Contextures website
<http://www.contextures.com/xlPivot01.html#Dynamic . I have multiple pivot
tables in my worksheet. I would like to set up the pivot tables so they
refer to the 1st pivot table, which references the dynamic formula range. In
the pivot table wizard,when I change the data source for each of the pivot
tables to the 1st pivot table, click "finish" and go back into the wizard to
see what data the table is referring to, it always comes up with the dynamic
formula, not the 1st pivot table.

I believe the drawback is that you have to refresh each pivot table
individually. Is there anyway around the issue? We are rolling out a sales
reporting tool and believe the salespeople will get confused if they have to
refresh the query and every single pivot table(there are many). Is there a
way to refresh multiple pivot tables with one click?