Hi All,

I have developed a monthly timesheet workbook with a worksheet for each
week. All workers will use this and as each week is completed, i want them to
run a macro to copy the CURRENT WORKSHEET to a supervisor's workbook. The
super's book will then have that week from all workers in one location so he
can just open his book and see all the worker's weeks.

In their worksheets, the worker's names are in cell B1 so it would be really
nice if the copies of the worker's worksheets were renamed to the name in
cell B1.

Thanks in advance for any help or suggestions.

Sammy