Sort with combobox

[Abaauw]

I am fairly well versed in excel, with the exception of complicated tasks (pivot tables, vba, etc.).
My employer is asking if I can make an inventory connected to the Bill of Materials spreadsheet. What this would entail is a drop-down for each inventory item I am inserting into the BOM. This is simple, but I would like to know if there is a way to have a separate combobox used to sort the list of inventory items by columns. It would be able to sort by description, part number, series, cost, or any of the other column titles. And with this pre-emptive sort, I would like to browse the hundreds-thousands of parts with the remaining combo boxes for the part we are looking for, select it, and it will automatically fill the remaining fields of important information (description and cost).

I do believe that this would be most useful if there is a separate 'Master' excel file, with the inventory, contacts, and what-not. This would have to be linked to the basic blank BOM form.

Any help will be much appreciated.

[Kyle123]

I think you should be looking at dependant validation, have a look here and see if it gets you started

http://www.contextures.com/xldataval02.html

[Abaauw]

Kyle,
Thank you, this seems very relevant, and a much better option than combo boxes. Now is there a way to make it auto-fill the price when I select an item number?

[Kyle123]

Without seeing your workbook it's difficult to make a suggestion, but probably VLOOKUP()

[Abaauw]

I am uploading a sample inventory list. Each list is on a different sheet (not necessary, but useful in organization). The lists are from row 2 to row 35 on all of the lists. I am having trouble writing an equation to perform data validation, referencing information on different sheets.
It should be simple:
=INDIRECT(C5!C5)
That is what I tried. I used this because the sheets and lists are labeled the same. Also, I do not believe VLookup will work for autofilling if the lists are on the same sheet because vlookup looks up the leftmost column (right?) and the lists would be in separate column groups (ex: WeldYoke from A-D, YokeShaft from E-H).
edit: The data validation I was trying with the code was suppose to occur in B5:B19


Just some thoughts on my part. If I am making this too complicated, let me know.

OH! And for future reference, this is the BOM format we are looking at using. It is located on the SampleBOM sheet.