I want to combine the totals of four sheets into one.
I am creating a spreadsheet to keep track of the hours spent each day working on different project (M-F).
I have five days of data. They all have the same layout.
At the end of the week, I want to add up each row's sum for m-f and put in a separate sheet called end of week total so I can see how many hours each week we spent on a project. I am basically creating a spreadsheet for each day of the week that shows how many hours my employees worked on each project. At the end of the week I want all of the hours to add up, but only for each a specific row. not the total number of hours.
I have no idea how to combine sheets.