Why not just link the cells with a formula? So when the workbook
is opened/calculated the second sheet will be updated with the
first sheets data or such. Add this formula to sheet1!A1 and it will
populate sheet1!A1 with Sheet2!A1
Code:
=CELL("contents",Sheet2!A1)