sheet name

[Petros]

Hi!
Is there a function that gives me the name of the sheet in a cell?
Thank you

 

[Gary''s Student]

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