Macro To Update Sum Of Working Hours For List Of Employees From

Need VBA macro to read and sum data from multiple worksheets

The “summary” worksheet contains list of all employees. I need to update the total number of hours for each employee by scanning all worksheets in the workbook as follows:

Once I click on a "update" button, I need to scan all worksheets (I have one worksheet for each week) which contains the total number of hours for employees by week. I need to calculate and add the total number of working hours for each employee then move to the next worksheet and so on ..

Once all worksheets are all scanned, the final total of working hours get posted in front of the employee name in the assigned field.. I need to do this for all employees. I also need a macro to create a new worksheet.. I attached an example with little description inside .. Labor Detail Job to Date-2.xlsx