Change lookup of Match function

[JuanPerdomo]

I have some sets in different sheets. I want to use the match function to be able to use the different names of those sheets by dragging down my formula.

 

[JuanPerdomo]

Sorry my text was not clear at all. I want to change the look up array so I can drag down and use the different names of the sheets-

 

[Peter_SSs]

Welcome to the MrExcel board!

Bit of a guess since we can't see what is on the other sheets, but try this

=MATCH(E$3;INDIRECT("'"&P3&"'!$B$3:$L$3");0)