Help tracking daily progress using only one form

[Organicsplus1]

I'm looking to find out if it is possible to use a single sheet to enter data with the result tracked on a second sheet. Currently I create a new sheet every day to track my crews progress. The total result I get from the sheet I then copy and paste to a main sheet for simplified daily tracking. I now have 95 open sheets in one book from tracking with the first sheet containing my totals of the additional 94 sheets. I'm hoping that excel has the capability to utilize a single sheet to enter the daily data and the result is linked to a second sheet based on parameters i set i.e time stamp from the computer or each new result calculated.

[Cerbera]

Are you able to upload a sample file so we can see what you are looking to accomplish? Cheers

[Organicsplus1]

Sure, thank you for taking a look. The total page is where i would ideally like the information to go. The remainder of the sheets are identical with the totals listed at the bottom of each sheet highlighted in yellow.

Bennett Creek 2014 Spray Costing.numbers.zip