Hi All,
Here is a method to list all sheet names in cells using formula.
Hit Ctrl + F3, New | Name : SheetNames
Refers to: =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
In A2 and copied down (Prior to XL 2007),
=IF(ROWS($A$2:A2)<=COUNTA(SheetNames),INDEX(SheetNames,ROWS($A$2:A2) ),"")
XL 2007 and later:
=IFERROR(INDEX(SheetNames,ROWS($A$2:A2)),"")
Enjoy !!
Bookmarks