making cells show worksheet names in workbook. is it possible?

[Scott]

i would like to have a number of cells in a "summary"
sheet show the names of all the other sheets in that
workbook. i have tried using CELLS function to no avail.
can this be done without writing and running a macro, ie.,
is there a function?

 

[Arvi Laanemets]

Hi

=MID(CELL("filename";SheetToGet!A1);FIND("]";CELL("filename";SheetToGet!A1))+1;33)

When you change sheet name afterwards, the formula tracks changes
automatically.
The cell you are referencing to can be any, I used here A1
The last number in formula has to be greater or same, as length of
longest sheetname. There is some limit for sheetname length, but I
don't remember it at moment.


Arvi Laanemets