Using multiple match criteria across multiple sheets with indirect

[Conrider]

I wonder if someone can help me. I've been stuck on this for a while. I have identical multiple sheets in the same book. I am creating a sheet where I can pull data from the various sheets depending on the value in a certain cell which will reference the sheet title I want to get the data from. When the sheet has been identified I then want it to match certain criteria to get to a certain value. I've been trying to use indirect, index, multiple match but can't seem to do it. Here is my code.... =INDEX(INDIRECT("'"&B11&"'!$N$39:$AY$62"),MATCH(1,(INDIRECT(D11,"B11"!$E$N$39:$N$62)*(INDIRECT(B11&"'!$O$39:$O$62"=E11)*(INDIRECT("'"&B11&"'!$Q$39:$Q$62"=H11),0)))),26)

B11 is the cell in my main sheet that will change depending what sheet I need to get the values from. I then need to match certain criteria ( d11, e11, h11,) with ranges in that specified sheet.

 

[Conrider]

* The line of code is actually =INDEX(INDIRECT("'"&B11&"'!$N$39:$AY$62"),MATCH(1,(INDIRECT("B11"!$E$N$39:$N$62=D11)*(INDIRECT(B11&"'!$O$39:$O$62"=E11)*(INDIRECT("'"&B11&"'!$Q$39:$Q$62"=H11),0)))),26)

 

[Fluff]

Hi & welcome to MrExcel.
Try

=INDEX(INDIRECT("'"&B11&"'!$N$39:$AY$62"),MATCH(1,(INDIRECT("'"&B11&"'!$N$39:$N$62")=D11)*(INDIRECT("'"&B11&"'!$O$39:$O$62")=E11)*(INDIRECT("'"&B11&"'!$Q$39:$Q$62")=H11),0),26)

 

[Conrider]

Hi & welcome to MrExcel.
Try

=INDEX(INDIRECT("'"&B11&"'!$N$39:$AY$62"),MATCH(1,(INDIRECT("'"&B11&"'!$N$39:$N$62")=D11)*(INDIRECT("'"&B11&"'!$O$39:$O$62")=E11)*(INDIRECT("'"&B11&"'!$Q$39:$Q$62")=H11),0),26)

Thank you so much. Worked first time. What a brilliant resource. Have a great day

 

[Fluff]

You're welcome & thanks for the feedback.