The formula, "=Cell("Filename")" without the outside quotes will yield the
path and filename of the file which contains the formula. You could nest
that within another formula, I would expect, and get the reference you need.
Richard Choate

"Cynthia Gregory" wrote in message
...
I have a workbook that is updated with new sheet names about every six
weeks. The worksheets all contain formulas that reference the different
worksheets and when I change the sheet names, I have to go through the
worksheets and change my formulas to reference the new names. This is a
large workbook with over three hundred formulas within the different
workbooks.

What I would like to do is write the formulas to look at a cell on sheet
(let's call it sheetNames) pull the sheet name from that cell and then use
that name in it's formula. ex (='H:\BIT Corporate Load\BIT Metrics
CL03Fall\CL03Fall Cust Sys & Mvmt Plogs\CSCS Cycle
Data\Templates\[rsc-cycle1.xls]WAPI'!$E$6) I want to replace WAPI with the
sheet 'sheetName'!A1 data. This would allow for me to change the sheet
names in one place and all of my formulas would reflect the change.

I hope this makes sense. Thanks for your help.

--
Thanks,
Cynthia G.

"Information is just signs and numbers, while knowledge
involves their meaning. What we want is knowledge, but what
we get is information."
--Heinz R. Pagels