Multiple Pivot tables on the same sheet controlled by one filter

Hi All - Here's an interesting enhancement I'm looking for.

I have five pivot tables on the same worksheet. Each table is pulling from a the same source which is a cube that's been set up for our data base.

Each pivot table has the same set of filters. But each PT has the filters filtered differently with the exception of the transaction date.

I would like to only have to change the transaction date filter in the first table and then each PT change with it.

Any ideas?

Thanks in advance for looking into this.

Chris

I have a feeling this is next to impossible.

Am I right?