Synchronize PivotTable Items
 

I'm trying to synchronize three pivottables to be exact. The page-by
field was fairly simple.

Incase someone is trying to do this here's a real simple suggestion:

RVPName = PageBy cell name

PTName = Range("RVPName").Value
Sheets("Sales
Rep").PivotTables("SalesRepPT2").PivotFields("Regi onal
VP").CurrentPage _
= PTName
Sheets("Sales Rep Graph
Data").PivotTables("RVPH2H").PivotFields("Regional VP").CurrentPage _
= PTName
Sheets("Sales Rep Graph
Data").PivotTables("RVPPie").PivotFields("Regional VP").CurrentPage _
= PTName

What I cannot figure out is how to synchronize the items. If a
SalesRep drop-down contains John, Mary and Jane and the "master"
pivottable selects John and Jane I'd like the other two to do the
same. Is this possible? TIA.