Insert value of a cell as a filename

[Ralph Howarth]

Is there a way to insert the value of a cell as a filename for referencing a
cell in another workbook?

ex: =<FileName>!$Col&Row
where <FileName> is a variable text string indicating the name of the
workbook desired to be referenced.

The application involved is such that a user would open up an Excel file
that serves as a data conversion tool. To set up, the user enters their
account information by entering in thier ID number. The ID number is the
variable portion of the text string that a file name is named by.

ex: ="ReportName"+UserID+".csv"
where FileName is the Name given the cell containing the concatenated text
string and UserID is the variable portion of the file name by way of an ID
number of the target user to receive the report.

I have tried different syntax to have the variable be read as literal text
such as:

'FileName
'FileName'
'(FileName)
'(FileName)'
'=(FileName)
'=(FileName)'
'(=FileName)
'(=FileName)'

I will receive either a message of "That name is not valid" or an Update
Values prompt for "(FileName)" when FileName is a Name in the workbook whose
cell reference already has a value.