I have sales information, where each account is an entire sheet.

I have added SUM totals on certain columns on each sheet (same relative
column, that is, column D is always "Sales", column E is always "Tonnes",
etc.).

I'd LIKE to do a summary sheet. What I've been doing is copying all data
from the individual sheets into a new worksheet, and pivoting that.

Is there an easier way to just "grab" what I want from the top row of each
sheet, automagically?