Auto Update Cell based on A Sheet Name (not current sheet)

[MixedUpExcel]

Hi All,

I'm trying to put together a workbook with a lot of sheets.

I want to be able to have a sheet called 'MASTER' with headers eg. Cells A1 to A20 (there will be many more than this!)

I want Cell A1 to be linked to the tab name of Sheet2
I want Cell A2 to be linked to the tab name of Sheet5

etc

If the name of Sheet 2 is Rng1 then I want Cell A1 to show Rng1
If the name of Sheet 5 is Rng13 then I want Cell A2 to show Rng13

If Sheet 2 name changes (which is possible due to something I'm working on) to Rng5 then I want Cell A1 to change to Rng5 instead of currently showing Rng1

etc. etc.

I don't want to use VBA. I just want a formula.

I know there are plenty of formula's out there to get the current sheet name for the sheet where Cells A1 to A20 reside.. BUT I want the other sheet names in the cells not this current sheet name.

Anyone have an idea how this can be done please?

Thanks in advance.

Simon