IfError and IFS over multiple sheets

[MillicentL]

Hi There
I am trying to look for a Y in two columns on multiple sheets and have a defined answer. Here is an abbreviated formula. It only works for sheet one?! Does not look at other sheets (There are 6).
=IFERROR(IFS(VLOOKUP($A10,'ZAM Calc'!$A$3:$AZ$2000,13,FALSE)="Y","EME",(VLOOKUP($A10,'ZAM Calc'!$A$3:$AZ$2000,14,FALSE)="Y"),"QME",(VLOOKUP($A10,'ZAY Calc'!$A$3:$AZ$2000,13,FALSE)="Y"),"EME",(VLOOKUP($A10,'ZAY Calc'!$A$3:$AZ$2000,14,FALSE)="Y"),"QME"),"Gen")
PLease please help
Millicent