Linking tab names to a cell in the sheet

[Hankjam]

Is is the possible?

It would be neat.

Many thanks

Aj
<B6>
Ecosse

 

[RagDyer]

This will work *only* if the file has been *saved*:

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)