How can I auto-transfer data from one "Sheet" to another "SHeet"in an Excel file?

[FPRmentions]

I am trying to find a function that would link data on Sheet 1 of an Excel file to, for instance, Sheet 2 automatically. So when I change the date on Sheet 1 it also changes on Sheet 2.

Thanks for your help.

[#2]

If in Sheet2!A2, your want to link to Sheet1!A2, simply enter this:
=Sheet1!A2