vlookup and indirect as a parameter

[confusus]

Hello, need quick help with this one:

=VLOOKUP(DIR!D35;DIR!D1:E100;2;FALSE)

this one works...
but if i want to change "DIR" into INDIRECT function to the same sheet, it gives error
I created a column of sheet names already, an I was planning to hide it, just use it for the function, i have many sheets, and many columns in my main sheet,
this one does not work:

>> D4 call says: DIR

=VLOOKUP(INDIRECT("'"&$D4&"'!"&"$D$1:$E$100");2;FALSE)

I need this as soon as possible, thank you guys in advance!

[Glenn Kennedy]

Try:

=VLOOKUP(INDIRECT("'"&$D4&"'!D1:E100");2;FALSE)

[confusus]

It appears to be working now, actually I did ok with all the doubletripe quotage, it was the first parameter I was wrong about, at first "Word1 word2" didn't work, but now it does, i guess i had some extra spaces in argument, or something...

Thank You anyway!