I realized when I entered the formula in your sheet that I screwed up the formula. The index part should be indirectly referenced too....

=IFERROR(INDEX(INDIRECT("'"&$A3&"'!A:A"),MATCH(10^ 10,INDIRECT("'"&$A3&"'!$A:$A"))),"")

copied down

repeat for each column changing the A:A in the INDEX part to respective column in other sheet.

You may need to format the results to match the type of data you are pulling.