Insert Worksheet Names into Cells

H

Howardjnl

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
 
B

Bob Phillips

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)
 
Top