Create Worksheet from Template

[adakos]

Im looking for a way to create a worksheet from a template within a workbook. Allow me to explain ---
I use this sheet for general timekeeping.

I fill client name/activity, time, lcoation, Client #, etc.
What I am trying to do is to be able to check a box at the end of the sheet and have it create a new worksheet in the notebook with the name:
DATE-ROW#
(111309-14)

the sheet I am trying to use for the template is below.

Ideally, this is done through VBA, correct?
I can have it pull the information on my own, I believe...

Is this even possible in excel?

-Thanks in Advance!
-Adakos

 

[adakos]

hate to bump my own thread but I lost the abiltiy to edit :

I realize this wasnt in my original post:

Sub AddAsLastWorksheet()
 
Worksheets.Add (After:=Worksheets(Worksheets.Count)).Name = "MySheet"
 
End Sub

However, I am unsure how to link it to a check box, and make it pull information such as ROW number, and how to load a sheet from a template.. (or copy/paste)
Thanks again!