Creating a control sheet from multiple sheets

Hi all and thank you for looking.

Please see attached document which shows individual sheets with weighbridge information for loads that individual suppliers have delivered on a weekly basis. This information is taken from the weighbridge and copied from a csv file into the document. I would like to be able to corroborate the weekly sheets into the Control Sheet without having to amend the information on the weekly sheets.

On the control sheet I have filled in weeks 1-5 with the information that should be present.

I regularly use =sumproduct((INDIRECT("'"&C$1&"'!$N$2:$N$325")<>"")*(INDIRECT("'"&C$1&"'!$N$2:$N$325")={0,1,2,3,4,5,6,7,8,9})*(INDIRECT("'"&C$1&"'!$E$2:$E$325")=$A5)*(INDIRECT("'"&C$1&"'!$G$2:$G$325")=$B5)) and various Sum** versions but I can't quite alter it to make this (more simple!) one work.

In the past GaryBarlow, Special K and Glenn Kennedy have been very helpful.

All help greatly appreciated

Cheers,

Phil