Combining Data from multiple sheets...

[FogCat]

Hi.
I have three excel sheets all in the same workbook, the first has a bunch of
inventory information, the second has bin location information, and the third
has stock code # information. I'd like to merge some of the information from
all three sheets. Here is what each sheet looks like:

Inventory Sheet:
Warehouse #A1), Part #B1), Trimmed Part #C1), Useless Data through
(G1), DescriptionH1), Usage History data goes through to Column Y,
Warehouse1 Max QtyZ1), Warehouse1 MinAA1), Reorder QtyAB1), blank(AC1),
Warehouse2 Max QtyAG1), Warehouse2 MinAH1)

Bin Location Sheet:
Part #A1), Bin LocationB1), DescriptionC1)

Stock Code Sheet:
Part #A1), Stock CodeB1), Bin LocationC1),

Unfortunately the Stock Code sheet is for some reason, missing some of the
part numbers that are on the other lists, so its not an exact match,
otherwise I'd just add the stock code # column onto the inventory sheet.

The combined sheet I'd like to look like this:

Bin LocationA1), Part #B1), Stock code#C1), Warehouse1 Max Qty(D1),
Blank: (E1), Warehouse2 Max Qty(F1), BlankG1)

How could I do this?

Thanks for your help!

Fogcat