lookup part description and price from different tabs

I am trying to build an order form that will auto populate part descriptions and two different price feilds from multiple work sheets when I enter a line code and a part number. The workbook I am working with has 46 differnt sheets, one each from my different vendors and all have various amounts for rows. All of the collums are laid out the same in each sheet. I have be trying to figure this out for several hours and have no luck any help would be great.