List tab names in cell range

[Guest]

I have a large # of worksheets where the tab names will change. I would like
to list them on a separate worksheet that will reflect any changes made to
the worksheet tab. Is this possible or should I just re-type the list?

 

[JE McGimpsey]

You can list them using

=MID(CELL("filename", Sheet1!A1), FIND("]", CELL("filename",
Sheet1!A1)) + 1, 255)

Which will return Sheet1. If the tab name changes, the formula will
change to reflect the change.

 

[Guest]

You have no idea how grateful for your solution! Thanks so much!

You can list them using

=MID(CELL("filename", Sheet1!A1), FIND("]", CELL("filename",
Sheet1!A1)) + 1, 255)

Which will return Sheet1. If the tab name changes, the formula will
change to reflect the change.

I have a large # of worksheets where the tab names will change. I would like
to list them on a separate worksheet that will reflect any changes made to
the worksheet tab. Is this possible or should I just re-type the list?