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!