I have to compare 3 companies with seperate sheets for each company's product
list.
I have 34200 (rows)records for Co. 1
Col A is product ref #. Col B to I is product info, price etc.

I have 16387 records (rows) for Co. 2. Col A is product ref #. Col B to M is
product info.
I have 16121 records (rows) for Co.3. Col A is product ref #, B to M is
product info.

The product overlap across the 3 companies is 90%.
I need to align all three lists onto 1 spread sheet in order that I can
compare prices for the same product across three companies.

How to sort by product ref #, to get identical products on the same row and
bringing with the sort the detail contained across the rest of sheets.
End result may be
Col A to I, Co 1 detail, Col J to V = Co 2, Col W to AI = Co 3.

Would really appreciate some help.
Thanks

I have --
JOHNW