put formulae on the "next" worksheet that point back to the cells on the previous worksheet.