Hello TrebleC

I don't have time to give you a Formula at the moment, but 1) this will push it back up the pile & 2) might point you in the right direction.

Assuming the Main Data Sheet comes from a system data dump and will always fall into the same Columns you could use VLOOKUP or INDEX & MATCH Oscar at Get Digital Help has a great resource and wealth of knowledge.

SUMIFS and COUNTIFS might also be valuable

I'd place the Location TW0, TW1 etc in the each of the sheets then you could SUM the tonnage based on the Location and the Commodity.