I would like to use a cell value in a formula to identify a workbook name.
e.g. ='[File_Info!B2]1 - General Statistics'!$C$21

File_Info :- is a worksheet in the same workbook
B2 :- is the cell in the worksheet that holds the filename (OtherFile.XLS)
1 - General Statistics :- is the worksheet in OtherFile.XLS
$C$21 :- is the cell in OtherFile.XLS I would like to call

At the moment it is just looking for a file called "File_Info!B2", how can I get it to call the information from worksheet and cell "File_Info!B2" and then use the called information as the filename??