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.

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.

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.



