Formula to show first sheet name

[MOB]

I'm not sure this is possible, but I thought I'd ask!

Currently have a summary sheet that we have to manually change each day as a new sheet is added - the input is the name of that new sheet, and it drives an indirect formula.

Its not a major pain but I wondered if I could automate this somehow? Will always be the very first sheet.

TIA

 

[footoo]

https://exceljet.net/formula/list-sheet-names-with-formula

 

[MOB]

Thanks - I'm not quite sure what to put where though................I'm a bit of a VBA novice!

 

[footoo]

It doesn't involve any VBA. Just follow the instructions in the link.

 

[MOB]

Even this bit?

=GET.WORKBOOK(1)&T(NOW())

Looks like a formula but the link shows "GET.WORKBOOK is a macro command that retrieves an array of sheet names in the current workbook"

 

[footoo]

As explained in the link, create a named range called "sheetnames" with this in the RefersTo box: =GET.WORKBOOK(1)&T(NOW())

(Also, see the link within the link: https://www.mrexcel.com/forum/excel-questions/428957-list-worksheet-names-using-formula.html)

 

[MOB]

Ah I missed that bit, thanks