formula for tab value

[Alylia]

i want to show in a cell what is in the tab on the worksheet. please advise
how do i go about that.

 

[Gary''s Student]

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