Go To Sheet Named As Text In Button Caption

There is a 'Home' page with a button for each employee - clicking the button takes the user to the appropriate employee's timesheet

There is also an 'Add New Employee' button on the home page which brings up a form and allows a new employee to be added.

Each employee has only 1 worksheet (Which is created based on a blank template page)

When the 'Add New Employee' button is clicked a form pops up which ask for name, D.O.B etc. The user fills out the form and clicks ok. The template sheet is then copied, renamed to the employees name, and all relevent fields are added to the template sheet (based on the users input). A button is also generated on the home page with the employees name as a caption and when it is clicked it goes to employees timesheet.

I have almost got this working.

The only problem is this only works once, So For Example say i Add 'John' then i add 'Mary' on the home page i now have 2 buttons with 'John' and 'Mary' on them. The problem is as soon as a second employee is added (Mary), the first employees button(John) is linked to the second employee's Sheet rather than its own(Mary). and after the spreadsheet is closed the buttons dont work at all.

The link below has the spreadsheet i have made so far, you can test it out if my description doesnt make sense or you can see the code behind the 'add new employee' form:

############################################################
#### 'Add Employee' Button on Add New Employee Form ####
############################################################


Private Sub cmdadd_Click()


'check for Name
If Trim(Me.EmpName.Value) = "" Then ..............................