Reference Multiple Sheet Names on one sheet

[questforexcel]

Hi All,

I have about 15 sheets in one workbook, which are named using numbers eg. 12345, 54321, 65432....etc.

I'd like to reference/link the names of all these sheets on to one main summary sheet. This is different from referencing the sheet name within that same sheet.

Is there some way to do that.

Currently I am manually typing these out which may be prone to typo errors.

Thank you

 

[James006]

Hi,

It looks like you need to create your Sheets Index ...

see : https://www.extendoffice.com/documents/excel/3176-excel-create-sheet-index.html#a1

Hope this will help

 

[Fluff]

Another option
On the formula tab select Name Manager > New > in Name put SheetNames > in Refers to put =GET.CELL(48,INDIRECT("rc[-2]", FALSE)) > Ok
The in A1 on your master sheet put
=INDEX(MID(SheetNames,FIND("]",SheetNames)+1,255),ROWS(A$1:A1))
and fill down.

The workbook will need to be saved as macro enabled.