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)

North and South both use ID first and Quantity second.

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.

N-12 with quantity 6 is followed by S-03 with quantity 2 in the combined list.

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.

Microsoft’s Excel function reference