Question: how to copy total from one sheet to another in excel?
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.