2009 Template for Attendance: How do I add multiple tabs of employ

[Ashleysquared]

I was able to get the original dowload of this template to work properly but
when I copy and pasted multiples so that each employee has his own tab in the
file for tracking, it doesnt work when I enter the Vacation etc. in. Can you
help?
Here is the template:
http://office.microsoft.com/en-us/templates/TC103347271033.aspx?pid=CT101436151033

Any help would be greatly appreciated.

 

[Ron@Buy]

The reason is that each month has been range named, when you copy to a new
worksheet the range name still refers back to the original worksheet you can
see this by going to Formulas > Name Manager. I guess you can change each
individually, there must be a way to globally change this but I am unsure how
at this stage. I anticipate that others reading this will have the solution.