Reference Multiple Sheet Names on one sheet

questforexcel

Board Regular
Joined
Jan 18, 2019
Messages
89
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
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
36,150
Office Version
365
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,474
Messages
5,414,751
Members
403,543
Latest member
Phx007

This Week's Hot Topics

Top