How to Update the Worksheets field value based on updates done in Main Worksheet.

You should only enter the formula in the first row (C2) and then copy down the formula, this will automatically change the reference to column A to coincide with the next entry in A.

To copy the formula down, click and hold the little black square at the bottom right corner of the active cell and drag it down the column.

See attached.