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), Description:(H1), Usage History data goes through to Column Y,
Warehouse1 Max Qty:(Z1), Warehouse1 Min:(AA1), Reorder Qty:(AB1), blank(AC1),
Warehouse2 Max Qty:(AG1), Warehouse2 Min:(AH1)

Bin Location Sheet:
Part #:(A1), Bin Location:(B1), Description:(C1)

Stock Code Sheet:
Part #:(A1), Stock Code:(B1), Bin Location:(C1),

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 Location:(A1), Part #:(B1), Stock code#:(C1), Warehouse1 Max Qty(D1),
Blank: (E1), Warehouse2 Max Qty(F1), Blank:(G1)

How could I do this?

Thanks for your help!

Fogcat