In the sheet "blah1", the A3 is "apple", and the B3 is the price "$1". In another sheet "finding", I want to find all prices of foods in the column F, so I write
"=INDEX('blah1'!$B$1:$B$10000,MATCH(F2,'blah1'!$A$1:$A$10000,0))"
in G2.

But I have a lot of sheets blah2 blah3 and so on. So the column B in the sheet "finding" there are the names of those sheets. I want to change the "blah1" in the above formula to "Indirect(Address(1,2,1))", but the formula
"=INDEX(Indirect(Address(1,2,1))!$B$1:$B$10000,MATCH(F2,Indirect(Address(1,2,1))!$A$1:$A$10000,0))"
is wrong. I don't know where is wrong and how to fix it...