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.