Summarising data.

See attached for Formula solution:

In each Date sheet, add column AO formula in AO2, copied down to however far you want:

=IF(D2="","",SUM(S2,W2,AA2,AE2,AI2,AM2)>0)

Then in Summary Sheet, Formula in D2 to count number of TRUE in relevant sheet:

=COUNTIF(INDIRECT(C2&"!AO:AO"),TRUE)

Formula in A6:

=IF(ROWS($A$1:$A1)>$D$2,"",INDEX(INDIRECT($C$2&"!A1:A100"),SMALL(IF(INDIRECT($C$2&"!AO1:AO100")>0,ROW(INDIRECT($C$2&"!AO1:AO100"))),ROWS($A$1:$A1))))

adust ranges to suit your data in date sheets... then Confirm with CTRL+SHIFT+ENTER not just ENTER..

Copy down as far as you want.

Then Copy formula in A6 across all columns...

You will need to adjust the red range to match the columns in the date sheets, then confirm each with CSE keys and copy down.