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,