Linking Pivot table filters

Since you use Excel 2010, have you tried using Slicers?
1) Create your pivot table(s)
2) Select one of them
3) PivotTable_Tools.Options.Insert_Slicer
...Select a field to filter on...Click: OK
4) PivotTable_Tools.Options.PivotTable_Connections
...Check each Pivot Table you want controlled by that slicer.
...Click: OK

Now...when you select items to filter on...Each of the connected Pivot Tables will be impacted.

Is that something you can work with?...or do you need something else?