What needs to be true of the data used for consolidation?

When consolidating data by position, matching items must appear in the same cells or positions on each worksheet. This lets the spreadsheet combine corresponding values correctly. So the data should have similar items in the same positions in different worksheets.

AI-written and checked against the verified answer.