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 !!