I have several timesheets that I would like to use for each employee.
I would also like a summary sheet that has all of the employees in a drop
down menu. However, how do I do this,so that when I update an individuals
timesheet, the new sheet is also updated?

I have never used macros and have no idea what the simpliest way for me to
do this would be, other than having to update both the individuals sheet and
the full summary sheet, each time there is a change. I am sure that Excel and
you clever things out there have an easier way !!! :-)