Lookup values accross several sheets to create summary sheet

Hi

Season 1 and 2

Column N =IF($E4=5,1,0)
Column O =IF($F4>=3,1,0)

You have a choice
Lower: <
Lower and =: <=
=: =
Higher and =: >=
Higher: >

Then Dummy Column K =IF($B2="","",SUMPRODUCT(SUMIF(INDIRECT("'"&Sheetlist&"'!A:A"),$B2,INDIRECT("'"&Sheetlist&"'!N:N"))))
Column L =IF($B2="","",SUMPRODUCT(SUMIF(INDIRECT("'"&Sheetlist&"'!A:A"),$B2,INDIRECT("'"&Sheetlist&"'!O:O"))))