picking data from multiple sheets

A small problem which I hope someone can help with.

I have various sheets, all layed out the same.
Column A = part numbers
Column B = quantity

atm I have 3 sheets. with both of those columns filled in, up to 15,000 records...or so. Various part numbers.

What I want to do is have a new sheet colate the info, and give me the quantity of each part number.

The 3 sheets are from different orders, but each sheet can contain the same info.

So rather than go through the whole sheets counting the quantities of each part number, id like it to tell me.
I thought about a pivot table, but can't get that to work. Tried an hlookup, and was totally baffled.

so if sheet one had pn 111 at a quantity of 12. sheet 2 at 14 and sheet 3 at 4000.
sheet 4 would say, part number 111 - quantity 4026
and carry on down the column giving part numbers with the totals from all the sheets, leaving me a nice end sheet with everything I need.

Is this possible and have I explained it well enough ;D

that's excellent m8, many thanks. I'll give that a try and see what happens.

Hi ,You could try this.
Create a new sheet in your workbook called "Combine"
Run this code from there.
Result from all worksheets (Except "Combine") shown in New sheet "Combine" Columns "A" & "B"

Please Login or Register  to view this content.

Regards Mick