Try, in worksheet2, a formula like:
=worksheet1!A1

This will be a "dynamic copy" of wksht1 data. If they change, wksht2
will also change. The same effect will be created if you use Paste
Special... and click the Paste Link button.

HTH
Kostis Vezerides