Master timesheet w/multiple employees

[Abah]

Greetings,

I am looking for a solution that will enable me to capture time, monthly, from several employees and merge/consolidate data into one master file based on assigned project. Employees are assigned to at least one project and some are entitled to overtime if weekly hours exceed 40 hours (excluding vacation, sick days, holidays, unpaid leave, & other).

Day of Week
"Regular Hrs"
"Overtime Hrs"
Sick
Vacation
Holiday
Unpaid Leave
Other
"TOTAL Hrs"
Comments

Sorry, I can't figure out how to include the excel template that we are using.

Thank you so much for reading this and in advance for any help you can afford me on this matter.

 

[Yard]

Hi,

Don't really understand what you're after, but if that list is the column headings on a worksheet where you enter your data, then a Pivot Table will help you analyze it

 

[Abah]

Hi,

Don't really understand what you're after, but if that list is the column headings on a worksheet where you enter your data, then a Pivot Table will help you analyze it

Good morning Yard,

Thank you for responding.

I am looking to be able to consolidate/merge multiple timesheet workbooks into one master workbook. I will email employees the standard template for time entry and they will fill in their information and return to me. Employees are based in different states and are assigned to different projects and clients. I wish Excel to then be able to update the master workbook based on updated information for each category/row/field. Bonus if doable, will be to be able to update the master workbook without having to open the updated workbooks. I will save all the files to one location/folder.

I hope this clarified my need.

Thanks, Aissa