Auto populating templated workbook

[DataVanMan]

Completely stumped on this one. What I am trying to do is generate a post job report, with all the pertinent data consolidated nicely into one workbook. I have managed with some help to get the TR worksheets to transfer from their workbook into a templated one.
Now what I would like to do is have the cover page in the templated workbook auto populate the corresponding data from the TR worksheets.
Also, and the most important, is I would like the data from the TR worksheets auto populate a totals sheet. (see attached) I originally wanted to create a separate totals sheet for each TR worksheet that gets transferred, however I was told it would be easier to have all that data transferred into one sheet, separated into a pivot table, of which I know nothing about.

So basically is there a way to take the corresponding data from the TR worksheets and auto populate a totals sheet for each TR, then have a master totals for the hole job??

The way it works currently is within the example treatment report within the TR sheet is a button labeled Export to Post Job Report. Once pressed it takes all the TR's from that workbook and puts them into the templated workbook with a cover page, then promps to save as. (the example file is the templated workbook)