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.