Hi,

I am trying to create a repeatable project timesheet dashboard, where on a monthly basis it will consolidate team timesheets and analyse them.

Attached is the dashboard "Dashboard Example_v0.1" along with 5 team members timesheets for February.

Help Files.zip

What I require:
-Copy worksheets (week 1 to week 5 excluding the summary sheet) in each team members timesheets to the "Dashboard Example" workbook.

-Rename the copied tabs to include the initials of the team member it came from. (eg. "week 1 - AH", "week 2 - AH", "week 1 - JB", "week 2 - JB")

The complication (refer to "Dashboard Example_v0.1")
-Team members constantly change in cell B12 - B18. Provision must be provided for not having the same number of team member every month. (Therefore the lookup for the team member timesheet workbooks needs to be dynamic.)

-Timesheets are done on a monthly basis, with the file name changing to include the month and initials of the individual. I have created a dynamic file name, cells H12 - H18, with the intention of the VBA code to reference those file names when searching for the respective workbooks from which to copy the worksheets.

I would appreciate your expert assistance on this.

Kind Regards
A-man