Q:

How can I link cells between two sheets so that value gets updated on the second sheet

I have a workbook with several sheets. I have dates on the sheets that i update to same value daily.
eg. on sheet 1, the date is in cell A1, on sheet 2, the date is in cell C2, does not follow a particular order but i update them to same value daily.
Is there anyway i can link the cells, so any change made in one affects the rest?

A:

In your example, why not enter the following formula in cell C2 on Sheet2?
=Sheet1!A1

Then you only have to change values on one sheet.

