Auto update of values

Hi I have several work sheets in a work book linked with macros. I have a cell in one sheet (closing balance) linked to another (opening balance) in another sheet. How can I automatically get subsequent sheets in following months to be updated (opening balance) from the preceding sheet (closing balance)?

Please provide the Spread Sheet it will be more helpfull to understand.