Question: how to transfer totals from one excel sheet to another?
Answer: Click the cell where you want the total to appear.
Type "=" without quotes (here and throughout) to alert Excel that you are entering a formula.
Click the bottom sheet tab and select the cell that contains the original total.
Press "Enter" to accept the reference and mirror the total.