In attachment is a version, where:
All attendancy entries are done in same sheet;
(As result), you can have any number of months without redesigning the workbook;
Summary is done on sheet Employees (you can have separate Report sheet, but this don't add any functionality, and adds complexity to design);
You can summarize any number of months, selecting start and end months for report period on sheet Employees.

Attached Files

Consolidate.xlsx (23.2 KB, 18 views)