"DRHannay" wrote:

how do I place the sheet tab name in my spreadsheet by formula?

Excel 2003

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