Automatically updating Pivot Tables across worksheets

[spencerbc4]

Basically I am trying to get this so when the "Client Name" on one Pivot Table is changed, it changes the Pivot Table on the other sheet to the same client and vice versa. The real worksheet has several more sheets, so I want to make sure it would update all sheets with a table