I have an excel spreadsheet for my accounts. I want to enable my spreadsheet to automatically repeat figures entered into one excel worksheet into another excel worksheet in the same work book.

Example:

Sheet 1, Cell A1 = 10

I want,

Sheet 2, Cell A1, to automatically update and = 10

Thanks in a advance.

Dan.