Loading a Table in a worksheet from another worksheet by using a drop down list

Hi all,

I'm using Excel 2010 and I need to get around this problem. I have a workbook with 2 worksheets. I want a drop down list in Sheet 1 that will show a specific table located in Sheet 2 (Sheet 2 has several tables on it) when the user selects a specific item from the drop down list. I have given specific names to the tables found in Sheet 2. Thus, if the user clicks "Table 2" from the drop down list in Sheet 1, I want that action to pull "Table 2" from Sheet 2 and display it in Sheet 1.
I've come across this before but can't find it in my bookmarks!! Do I need to use Data Validation List for this?

Solution found by using the INDIRECT function. Thank you FDibbins for pointing me in the right direction!

http://www.excelforum.com/excel-form...-relative.html