This is the formula I am using to return the name of the active worksheet.

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,25)

But what is the formula to return sheet names of other sheets within the same workbook? For example, I have 10 sheets in one workbook. In sheet1, I want to automatically reference the names of all 10 sheets.

Thanks