Single drop down list to change multiple pivot tables/charts.

[ZeDoctor]

Hi,

I know my title is a bit vague but I couldn't really think of how to describe what I require.

Basically I have lots of data that I have built multiple pivot tables/charts for. I want to be able to have one primary front page that will show my charts that show overall totals but then I want to be able to have a single drop down list which users can select a user from. Say they select "John", then all pivot tables/charts related to John will be shown and if they then select the next user "Mary" then all the data will change to Mary's data (the pivots/charts are all the same). I just can;t think of the best way to get started on developing something like this.

Hope that makes sense,

Thanks for any help,

Daryl.

[ZeDoctor]

As my initial question may have been quite hard to decipher, I've attached a spreadsheet that might help show what i'm trying to get at.

I'd want the charts on the primary tab as my home page and then a drop down list someonwhere on this tab that when I select John from this list it would remove the primary charts and replace them with Johns charts and then if I select Trevor his charts would appear.

Is this possible?

Thanks again :D

Example Sheet.xlsx