Template.xlsx
I need some help guys. I have a workbook with multiple sheets on it. Each sheet has tables in it. I need a macro that will copy from all tables into a master table so I can sort everything. I have included the template that I use. The employees have time in different areas of the sheets. It would be nice if the master table would add all their hours for that employee id based on the day. Basically I want to be able to sum all hours on one sheet and then see if someone was carried twice. The only problem is some employees worked at night also. What might work is if the macro can copy all employee id numbers onto one sheet and then sum all hours for that employee from all sheets.