Thanks, Joel. Hit some problems trying it out.

Prepared this sample set-up with 3 sheets: Cat1, Cat2, Master

In sheet: Cat1

Qty Part# ProdDesc
10 Dat11
2 10 Dat12
5 15 Dat13



In sheet: Cat2

Qty Part# ProdDesc
1 14 Dat21
15 Dat22
3 17 Dat23



Then in sheet: Master,
started with only the headers in A1:C1

Qty Part# ProdDesc


When the sub is run, the expected
results would be something like this:

Qty Part# ProdDesc

2 10 Dat12
5 15 Dat13

1 14 Dat21

3 17 Dat23



When I ran your sub, I got this in Master,
it hung so I CTRL+Breaked it

Qty Field1 Desc

1 14 Dat21
1 14 Dat21
1 14 Dat21

(Repeat interminably ...)

How can it be made to produce the expected results?

Max