Ok i have tried to look up several solutions but nothing seems to fit or answers my problem. I am trying to index and match across several worksheets. Here is my formula

=INDEX(Current1!$A$2:$D$60000,(MATCH(1,(Current1!$A$2:$A$60000=$O11)*(Current1!$B$2:$B$60000=$D$9)*(Current1!$C$2:$C$60000=$D$10),0)),4)
I have 11 subsequent "Current" sheets numbered in sequence. So naturally i tried

=INDEX(Current1:Current11!$A$2:$D$60000,(MATCH(1,(Current1:Current11!$A$2:$A$60000=$O11)*(Current1:Current11!$B$2:$B$60000=$C$9)*(Current1:Current11!$C$2:$C$60000=$C$10),0)),4)
but this is returning a "#VALUE"

Any thoughts?