Alright I am completely stumped on this one.

I currently have a sheet Called TR which carries information that you can update during a specific job.
I also have a TOTALS sheet that has formulas to take specific data from the TR sheet.
The TR sheet as a button that creates a new TR sheet that is blanked out for the next job to record information.

My problem is I would like the TOTALS sheet to either update from the TR sheets automatically, or at least have a button within the TOTALS sheet that will update this data.
As an example, there is a cell in the TR sheet that gives a numeric total for a specific chemical I used on a job.
The TOTALS sheet reflects that data in a cell as well as other totals. I would like that cell in the TOTALS sheet to update when I create another TR sheet with another total of the same chemical.

Is this possible??