d wrote:

I have inherited a new job which requires timekeeping/payroll via excel
for 125 employees. There is a template on the first worksheet which I
must change monthly and then copy and paste to each employee page. It
will save so much time monthly, as I have to manually enter the times
already.

I need to find out the following, if it is possible:

1)Is there a way to set up each employee's page so when the template
changes, then all employee pages change?

Probably. More info would help, but it could be as simple as "=Sheet1!A1" or
similar. (Depends on what info is being changed and how it's used, of
course.)

2) When a new employee is created, is there a way to auto create their
sheet from or to the template and the 'Master Employee' list?

Create a blank employee sheet with all of the appropriate information on it,
name it something like "New Employee Template", and hide it. (Right-click on
the sheet's tab and select "Hide".) When you need to make a new employee
sheet, unhide the template (right-click on any sheet's tab and select
"Unhide...", then pick the template), copy it, and then rehide it. Fill in
the blanks.

--
I abstained from evil and I was ultimately vindicated.