Formula to give list sheet names

Hello Excel Experts,

Say I have the following sheets in a workbook.

'Sheet1', 'Start', 'Jan', 'Feb', 'North', 'SomeName' , 'End', Sheet2, 'Output'

Say in 'Output' sheet, is there a formula that can give me a list of sheets in the current workbook?

Even better, a formula that give me a list of sheets that are in the range of sheets that are in between 'Start' and 'End'

Again...I'm looking for a formula. Try to avoid using VBA.

Solved: I was able to solve it by following the steps in https://www.extendoffice.com/documen...eet-names.html

Those who're lazy to look, basically the steps are.

1.) Create a name range formula (i.e ListSheets) and in the name range formula have it =SUBSTITUTE(GET.WORKBOOK(1),"["&GET.WORKBOOK(16)&"]","")
2.) In the 'Output' sheets at cell A1, use a formula, =INDEX(ListSheets,ROWS($A$1:$A1))

Not possible with a formula, sorry. It will require a UDF (User Defined Function) which is a small macro - which is pretty much what your link showed