index function

[BobtBuilder]

I have this formula (=INDEX(ListSheets,3) which gets the name of the sheet number, in this case 3, but if I rename the sheet it does not automatically change the name, I have to go into the formula for it to change.
Why? Anyone have a workaround?

Thanks

 

[Mackeral]

Keep the sheetname in "NAMES", and reference it whenever you need to use it.

 

[Fluff]

What is the formula used to create ListSheets?