Using VLOOKUP with cell data for table array

I am having some problems using data from a cell as a table array in VLOOKUP.

Here is my lookup formula

=VLOOKUP(B41,INDIRECT("'"&$D$23),11,FALSE)
the " " in the indirect formula are including the ' at the beginning of the following location, that when put into a cell, magically disappears. The following information is in the D23 cell that i am trying to reference.

S:\BCI Quality System\Environmental\EPA\EMISSIONS LOG\[2011 Emissions.xls]April'!$B$5:$O$26

Right now i am getting a #REF error and don't know where to head. I have toyed around with the INDIRECT function but have thus far failed to return any information. OR am not sure if that is where my troubles reside.

Please advise me in a direction to head.
Thanks in advance.

Yours truly,
Someone in need of help

Thanks a lot i decided to go along with the method of just having to have the other workbooks open. I was unaware of this stipulation. Thanks again for your help.