Import data from other sheets depending on dropdown selection

I am working on a master spreadsheet that will populate it's contents based on the drop down selection. I have 58 total spreadsheets that are all unique with different part numbers and prices that will eventually all be called to the one Master Price Sheet.

The master example I am including is called Test_Pricing_Sheet_1-12-2011.
I am also including two other spreadsheets of the total 58, since the current drop down only has these two until I get it working, at which time I'll change it to use all 58.

Basically, I want to keep the top section that has the customer info, etc as well as the bottom info that calculates tax, freight, discounts, etc. When I make the selection in the drop down, I want it to call all part numbers and pricing information from the appropriate sheet. So in the first selection, Ancestral Rope, I want it to go to Ancestral_Rope_MW_US_rev-1-5-11.xlsm and grab all of the information from lines 13 - 262 and populate the master sheet with this information. If the next cabinet is selected, Antique Heritage, I want it to go to file Antique_Heritage_FC_US_rev-1-6-2011.xlsm and grab all information from lines 13 - 229 and populate the master sheet with this information. Remember, this going to need to be done for 58 total sheets.

Notice all cabinet spreadsheets have different skews, prices and number of skews.

I hope this is clear enough to understand and I don't get flamed for attaching 3 files. I am new to this forum and not quite sure on proper etiquette on attaching files, etc.

If someone has a better way of doing what I am trying to do, I am all ears.

Any suggestions?