HOW DO I COPY A TOTAL FIGURE FROM 1 SHEET TO NEXT ADDING RUNNING T
 

I HAVE MADE A WORKBOOK FOR A MONTHS WORTH OF SALES AN D OTHER STOCK ENTRIES.
1 HAVE TODAY, YESTERDAY AND TOTAL IN EACH SHEET.
I WANT TO COPY TOTAL FIGURE INTO YESTERDAY ON EVERY SHEET.
IS THER A WAY OF DOING THIS WITHOUT PHYSICALLY TYPING IN THE REFERENCE TO
PREVIOUS SHEET.
EX. SHEET 2 REFERS TO SHEET 1. SHEET 3 REFERS TO SHEET 2.

CAN ANYONE PLEASE HELP ME
THANKS
--
SANDRA