As long as the file is open, you could enter the filename in, say, cell
A1 and use:

=INDIRECT("'[" & A1 & "] Chicago'!L205")




In article ,
ed9213 wrote:

I have to make comparisons of data monthly with files whose data are in the
same positions within the worksheets, but whose values vary each month.

I created a template with links that will read a cell in a particular file
(i.e. ='[12-06 Ops Stmt.xls] Chicago"!$L$205) and if I manually copy and
paste links I can create the comparisons I need.

Every month the file name changes. I would like to create a cell in which I
enter the new filename and modify the formulas so that the formulas in the
cells pull that filename from that cell and populate my comparison sheet.

I think I explained that right.

Is it doable?

Thanks.

Ed