join multiple pivot tables?

[clueless_in_mempjhis]

How can I link up multiple pivottables all based on the same data where all i
would have to do is change the page option (drop down menu) from the first
pivot and the rest of the pivots would automatically adjust to match those?

 

[Debra Dalgleish]

There's a sample file here in which you can change the page field in one
pivot table, and all the related pivot tables change:

http://www.contextures.com/excelfiles.html

Under Pivot Tables, look for 'PT0021 - Change All Page Fields' or
'PT0008 - Change Multiple Page Fields'