North and South maintain separate stock sheets. You need a combined list that keeps both teams’ records in one view. Check that both sheets put ID and Quantity in the same order.
Stack the rows beneath a single header
On North, put N-11 with 4 and N-12 with 6 in A2:B3. On South, put S-03 with 2 and S-04 with 5 in A2:B3. Add ID and Quantity headings on a third sheet and enter this beneath them:
=VSTACK(North!A2:B3,South!A2:B3)
Illustrated source check. Leave both source headings outside the formula.
Check the transition between sheets
N-12 with 6 should be followed by S-03 with 2. Check that there are four data rows and their quantities add to 17. If an ID row says “Quantity,” one of the inputs includes a repeated header or has its fields reversed.

Illustrated seam check. The four quantities add to 17.
Expand the input ranges when more records are added, or use compatible growing references and verify that they pick up new rows. VSTACK keeps duplicates, so reconcile them separately when the result is used for reporting.



