access vba courses in london - Copying a numeric total to another worksheet

How do I copy a numberic total (that is the result of a formula) automatically to a cell on another workseet? e.g. a closing sales total that you want to be the opening sales figure on the next worksheet (without the formula copying)