I Have a workbook with a number of sheets one is Stock with headings
"Item(Number) Category, Stock, On Order, Sold then sizes 7*5, 6*8, 9*6, 12*9,
A3.

I have another sheet which has Item No. Name, Cat,

What I want to have is another sheet with the two previous sheets
amalgamated onto it. Slight problem though. The sheet Stock has a slightly
different number of Items and in a slightly different order than the second
sheet. How can I get round this. I understand that the Item number would be
the identity point between the two sheets but not sure how I can collate the
data so that the right number (Size) goes to the right Item.

Not sure if this made sense, and appreciate any help you can give me.