Insert Worksheet Names into Cells
 

I'm creating a summary sheet of names of work sheets, all in the same
workbook, that will vertically list the sheet names in a column. I want to
be able to change the work sheet names on their respective tabs and have ths
automatically reflected in the list on the summary sheet. Is this doable,
and if so, how might I go about it?
John

Insert Worksheet Names into Cells
 

In the master sheet add formulae like

=MID(CELL("filename",'my Sheet'!A1),FIND("]",CELL("filename",'my
Sheet'!A1))+1,99)

changing 'my Sheet' for each of the sheet names. When a sheet names changes,
the master will auto-update.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Howardjnl" wrote in message
...
I'm creating a summary sheet of names of work sheets, all in the same
workbook, that will vertically list the sheet names in a column. I want
to
be able to change the work sheet names on their respective tabs and have
ths
automatically reflected in the list on the summary sheet. Is this doable,
and if so, how might I go about it?
John