Try

=MATCH(B2,INDIRECT(A2&"!A:A"),0)