I want to take this name and place it in a cell in the workbook, and if the
name of the sheet is changed I want it to reflect the change

One way, from a posting by Richard Schollar:
=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")

The workbook must have been saved beforehand
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---