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