In order to get the Names of the Sheets in any column as mentioned by NBVC, define A Name - Sheet and insert this formula in the Name define window..
Sheet - SUBSTITUTE(GET.WORKBOOK(1),"["&GET.WORKBOOK(16)&"]","")
and then Lets say you want this to appear in the column A from A2 onwards then...
[ IF(ISERROR(INDEX(Sheets,ROWS($A$2:$A2)))," ",INDEX(Sheets,ROWS($A$2:$A2))) ]
Then you can use the IINDIRECT function..
Bookmarks