How do I use Excel to show a list from a sheet in a second column, dependant on the first column?

Hi - I have a drop down list in column A - lets say 1, 2, 3, 4.    That list relates to one of 4 sheets of data, say sheet 1, sheet 2, etc   If I select 1, I want it to only show a list of data f...