I use D1 to track the worksheetname.
D1
=MID(CELL(""filename"",Sheetname!A1),FIND(""]"",CELL(""filename"",Sheetname!A1))+1,255)

Is it possible to have it in reverse?
i.e. to change the name of the worksheet to what is in cell (D1)
Thanks