The daily dispatch sheet starts with a title, a generated date and a column-heading row. The counts below them need a clean range for another worksheet. Use DROP to build that view without editing the imported block.

In a test sheet, use A1:B7. Put the title in row 1, the generated date in row 2, and the headings Location and Crates in row 3. Enter Pier A–6, Pier B–2, Depot–9 and Store–4 in rows 4–7.

The source report marks its title, generated date and field headings above four dispatch records.

Example source. Count the leading rows before the first actual record.

In E2, enter =DROP(A1:B7,3). Leave E2:F5 clear. Expect four records and check that Pier A still shows 6 and Store still shows 4.

The output starts at Pier A and preserves four location-and-count pairs.

Example output. Verify the first and last retained records.

Change the Depot count in the source and confirm the result follows it. If the next import has an extra preamble row or more records, check the offset and input range again. A fixed three-row drop depends on that report structure.

Microsoft’s DROP reference.