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