reference same cell on multiple worksheets

I agree with oeldere. If you can do this in one table, then you can use a pivot table to divide out and sum up anything you want. Just to show how it could be done I attached a file with the first two days put into one table. There is also a pivot table showing how it can add up everything you would want to see.

I know the table looks big, but it is easy to enter new information and not a problem at all for Excel to handle thousands of rows.