Displaying a named range on another sheet from a dropdown list selection on sheet1?

Hello ExcelLers!! I hope this is really easy for some of you out there, because I am not having much luck. Here's the situation:

I have a table with information on sheets2 to sheet10. The table contains information about different contractors my company uses for work. On Sheet1, I was hoping to create a dropdown list of the 9 contractors and, based on the selection, have that corresponding table from sheet2 to sheet 10 be displayed.

For example, on my dropdown list I might have "Contractor A" which have a table of information on Sheet2, "Contractor B" has a table on Sheet3. If I chose "Contractor A" on the dropdown list from Sheet1, I wanted the table on Sheet2 to show up on Sheet 1. But after, if I wanted to pick "Contractor B", I want the table to change to the table on Sheet3. Know what I mean? Is this possible without code? Thanks for your help!!!!