how to create a drop down list that selects data from different tables

[inkedsailor]

Hi all,

I am new to the forum and am hopeful that you learned excel types can help direct me to a solution.
I am working a data sheet for our companies recruitment team.
I have created 3 tables that are identically formatted with department column headers and month row labels.
the 3 tables show "plan", "actual against plan" and "actual total".
What I would ideally like to do is using a dropdown list for the 3 table names above and have the drop-down copy its associated tables data into another blank formatted table.
I can then from this 4th table create a chart.
The idea behind this method rather than have 3 separate charts on a dashboard is that I can then apply another combo box to select different data for the chart such as a department.
Thanks in advance.

 

[anglais428]

You could use a pivot table for this.

 

[inkedsailor]

Thanks Anglais, Ill have a look. I never seem to have much luck with pivot tables. I perhaps need to spend more time using them.