Tab names

[jgolden]

I want to be able to reference the name of the tabs in the workbook in a summary sheet. However, the order and name of the tabs may change. How can I combine the index number to reflect the name of the tab into a cell on the summary sheet.

Thanks

[mdmackillop]

You can use Indirect to refer to a range or sheet named in a cell
=INDIRECT(E18 & "!A1")
where the sheet name is in cell E18.
Is this what you're after?

[Bob Phillips]

If you create a list like so

=MID(CELL("filename",'worksheet 1 name'!A1),FIND("]",CELL("filename",'worksheet 1 name'!A1))+1,255)

for each worksheet. You have to put the name in for the first time, but every time it gets updated, so does your formula.