I want to link sheets with cell references and file names as
parameters. I tried address function but it did not work.

Cell a1 would be the file and sheet name /excelfile.xls!sheet1

second file would just type the filename and the range.

TY

Allen