Hi! :)

I would like to show the worksheet tab name in a cell of that specific worksheet?

Is this possible with a formula in a cell?!?

Try this:

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

You have to save the workbook first if it is a new workbook.

Try this:

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

You have to save the workbook first if it is a new workbook.
Nice one. That is amazing!