Vlookup with concatenated table array?

Hi all,

A brief outline of what I am trying to achieve..

I have a set of "Import tables", where values in tables can be defined for a number of different scenarios. In a separate workbook I have a list box which is populated with the names of these files. The user is to choose a pre defined scenario from the list box. This populates a cell which I am using to concatenate with the file path and relevant range etc.

The concatenated file name is then referred to in a vlookup formula to return the values from the scenario selected. I have done something similar before, but the "Import tables" workbook names were defined by myself, however this time the user defines the name of the "Import Table" to reflect the editing of the scenario.

I cannot get this to work and am yet to find a solution on the net. If anyone has come across something like this before I would be grateful of any input!

Many thanks!

Please also note that I need to refer to a closed workbook, so the INDIRECT function is not an option!