Choosing one table from many and copying it to a new location

I have one worksheet with many price lists for different products. They are tables with prices based on different heights and widths in each table.

In a separate worksheet a person must choose one of these tables from a drop down list and based on this choice the correct table must be copied to a specific area in the new worksheet.

Is this possible without using macros and if not how can it be done?

Originally Posted by msexcelathome

Please attach a sample workbook..

See attached. Two tables and you make choice in cell Q5

Based on that choice the correct table must be copied to range starting at cell S5

Each table is named accordingly. So from choice in Q5 the table with that named range should be copied