auto fill cell with sheet name

hi,
i need to rename a daily sheet with the date on the tab at the bottom of the sheet. how do i get this to autofill into a specific cell on the sheet? eg 4.11.13 to cell a1.

I think you

I think you want:

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

Chris