Searching matching vertical and horizontal criteria in multiple sheets

Bloozntooz,

I noticed your profile says Excel 2003, but you uploaded an .xlsx file; try this and see if it works for you. (I don't recall when COUNTIFS was introduced or if it will work in 2003 version.)

With a helper column listing the sheet names in R2:R3 of Tracking sheet this array-entered formula in C3 filled down and across to G6

Formula:

=IF(SUM(COUNTIFS(INDIRECT("'"&$R$2:$R$3&"'"&"!$B$3:$B$5"),$B3,INDIRECT("'"&$R$2:$R$3&"'"&"!$c$3:$c$5"),C$2,INDIRECT("'"&$R$2:$R$3&"'"&"!$d$3:$d$5"),{"Early","Ontime","Late"})),SUM(COUNTIFS(INDIRECT("'"&$R$2:$R$3&"'"&"!$B$3:$B$5"),$B3,INDIRECT("'"&$R$2:$R$3&"'"&"!$c$3:$c$5"),C$2,INDIRECT("'"&$R$2:$R$3&"'"&"!$d$3:$d$5"),{"Early","Ontime","Late"})),"")

Array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

The file is attached.

Does this do what you want and is it scalable for your future use? The keys are the helper range and INDIRECT.