Variable Filename calls
 

Ok, Here's another thing I'm having trouble getting to work. I would
like to concatenate a file and cell name to use to retrieve a value. I
have a master sheet that contains a filename value in a cell. I would
then use the filename value contained in that cell to call a value from
another sheet. Here is an example of what I mean:

File_Names.xls!FILE_SALES_JUNE_2006

['FILE_SALES_JUNE_2006' is concatenated, cell contains value...]

----
Sales_June_2006.xls
----

I would then use that value to call a concatenated cell value from
another sheet

Sales_June_2006.xls!S_1001_1


['S_1001_1' is concatenated, cell contains value...]

----
8804 <----- value needed
----

I concatenate the needed filename correctly, I just can't seem to get
resulting values to be used in the file/cellname call. How would you
get a "File_Names.xls!FILE_SALES_JUNE_2006" command to accept a variable
as a cellname and a "Sales_June_2006.xls!S_1001_1" to accept cell value
and variable name as both the filename and the cell name in the call.
Thanks in advance for any help.

-Daniel Canham