cell=sheet name

[Guest]

My summary sheet requires cell entries of the sheet names within the same book to be listed down a column, however the book starts with a Summary Sheet and Sht(1). Additional sheets will be copied from Sht(1) as required. My intent was to enter a formula "cell=sheet name" in a cell on Sht(1), enter the reference to that cell on the Summary Sheet for the fifty or so sheets that don't exist and format the cells not display text until the related sheets are created. Is there a safer or better way and if so how? Would you please show me the formula for "cell=sheet name" less the path & book name?
This would be greatly appreciated.
Thank You,
Daryl

 

[Frank Kabel]

Hi
Use (just insert the formulas as-is. Note: the workbook
has to be saved before)
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)
+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL
("filename",A1),1)-1)

-----Original Message-----
My summary sheet requires cell entries of the sheet names

within the same book to be listed down a column, however
the book starts with a Summary Sheet and Sht(1).
Additional sheets will be copied from Sht(1) as required.
My intent was to enter a formula "cell=sheet name" in a
cell on Sht(1), enter the reference to that cell on the
Summary Sheet for the fifty or so sheets that don't exist
and format the cells not display text until the related
sheets are created. Is there a safer or better way and if
so how? Would you please show me the formula
for "cell=sheet name" less the path & book name?