master sheet

If I was doing it the way I would want to would be to have a total each day being created because if you SUM everything and do those totals then your mileage will be HUGE.
As such you need to have a program not a formula that will look for each day and update it daily. Unfortunately I believe that is beyond my abilities as I am much better with formula and linking etc that with programming.
However what if you did the reverse entered the information on the master sheet and then it filled in the rest? Still a little time consuming but off the top of my head probably easier.