Hi,

I want to look up values in one specific range in many different sheets. I could define the range manually in each sheet.
=VLOOKUP($D10;Banan!$A:$F;H$4;FALSE)
=VLOOKUP($D10;Apple!$A:$F;H$4;FALSE)
=VLOOKUP($D10;Strawberry!$A:$F;H$4;FALSE)

But that will take too much time (70 different sheets). Instead I would like to reference the name in a cell.
A1=Banan
A2=Apple
A3=Strawberry

I then want to use the VLOOKUP like below:
=VLOOKUP($D10;A1!$A:$F;H$4;FALSE)
=VLOOKUP($D10;A2!$A:$F;H$4;FALSE)
=VLOOKUP($D10;A3!$A:$F;H$4;FALSE)

I am not able to get this right.

Appreciate Your help!!!