Sheet naming Macro help

[Firecop1348]

Last time I should need help.
I have a workboook that im starting to use for workorders. My main page has a button with a macro that when I click it makes a copy of my main workorder and I do what I need to with it. The sheet are named Workorder (2), Workorder (3) ect... My question, Is their a way that the name of the sheet can be automaticly put into a cell on the sheet when the workorder is created?
Example, I click on button, main workorder is copyed, workorder (4) is created <--already have and working, in cell E5 the name workorder (4) is automaticly entered into sheet workorder (4) . Same with workorder (5) ect ect ect...

 

[VoG]

Try

With ActiveSheet
    .Range("E5").Value = .Name
End With

 

[Firecop1348]

WOW it works great, right from the start.
Thank you

 

[VoG]

Sorry, I don't know about the background. Please start a new thread about that.