Hi i hope you are doing great, I would like to request that i am using this code since you made but know i want to understand this code would you please add comments in VBA code section that which line does what.
Question: How many years experience do You have with coding VBA? If You do not have experience of coding VBA, then You should try to study it eg from these pages https://chandoo.org/wp/vba-classes/
or You would run that code line-by-line and see - what is going on ...
That way, You could understand that code.
To generate a summary for multiple people (ref #7) the named ranges 'Name', 'In', Out' and 'Comment' each are changed to be column relative e.g. =Data!C$3:C$33
rather than =Data!$C$3:$C$33 If the staff each had a separate sheet then local names would have had to be replicated for each sheet.