Is it possible to auto name a tab within a workbook based on a cell reference?

[cwashburn]

I have several budgeting workbooks in Excel 2003 that are used by my companies field staff to input data. The inputs they choose within the header creates a unique budget number and each tab within the workbook represents a single unique budget. I currently have the field staff "copying" and "pasting" the unique budget number from the cell where it resides to the Tab name in order to clearly identify that tab within the workbook. Can this process be automated? I could create a macro button to perform the task but thought it might simply be able to be automated and I can't seem to figure out how to do it...

Thanks in advance for any guidance even if it is to tell me it can't be done!

 

[Redwolfx]

This is simple on deactivating any worksheet.

Paste this into the Thisworkbook

If you have some sort of Template you may want to add something like IF Sh.Name <> "Template" Then

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
Sh.Name = Sh.Range("A1").Value ' Change the Cell Reference
End Sub

 

[cwashburn]

Thanks