List tab names in cell range
 

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?

List tab names in cell range
 

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.

In article ,
JN wrote:

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?

List tab names in cell range
 

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

"JE McGimpsey" wrote:

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.

In article ,
JN wrote:

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?