I'm trying to link a cell to a different cell in another workbook, however cannot change the absolute reference of the filename in the formula, e.g =[Book2]Sheet1!$B!2.

Is it possible to use a cell reference (i.e A1) in the square brackets in the above formula? I keep getting error messages due to excel looking for the file A1.xls