How to populate a table with data from tables on other sheets using a drop down list.

[methclubseven]

I am trying to populate a main table using a drop down list whereby each dropdown option extracts data from a table from its respective sheet. All the tables are of the same dimensions. Example: I have 3 populated tables for Types of insurance claim down the y axis (public liability, flood, fire), and whether these claims are 3, 2 or 1 year old across the x axis. The values will be how many of these claim have been made, separating them by age. The three tables are the based on whether these claims are under review, partial payment has been made, or no formal claim has been made respectively. I want to use a drop down in an empty table to alternate between these three tables.