HELP on a variable in formula

[hamedallah]

=ADDRESS(1;1;1;1;"[11111.xlsx]Sheet1")


I Would like to give the name 11111.xlsx as a variable in a cell, beacuse i have diffrent file names i want to enter file names in a cell and formula read the file name from a cell.

=ADDRESS(1;1;1;1;"[R1C1.xlsx]Sheet1")

R1C1 contains the file name that i want to use in formula.

THANKS

[Ace_XL]

Consider the INDIRECT function

[hamedallah]

Is it possible to use a variable instead of 1111.xlsx ??