Update values based on drop down list

I have a list of tables that have a similar structure. I would like to make a new (single) table with a header that contains a drop down list of the options. In my example, sheet 1 contains Northeast, Southeast and Gulfcoast followed by a table of values, respectively. I would like to reduce this to a single table, as in sheet 2, where the drop down includes Northeast, Southeast and Gulfcoast and when the corresponding location is chosen, the values update. I have no trouble with vlookup or creating the drop down list, but I cannot seem to make an array of values update based on changing the drop down list value. Many thanks in advance,

In Sheet2 cell B3

Please Login or Register  to view this content.

Drag Across and then Down.

Can you take it from there?