You could use the first summary sheet to collate the information from each month sheet, by employee name, and then use a 2nd summary sheet to sum up the total for the year. That is how I would do it, but there might be a way of doing it that cuts out the collating sheet.