Mirror or link cell to source cell when copying between sheets.

Nope, does not accept Link:=True at all

Hello and thanks for reply, really appreciate your help. The last code did something different from the original one, but not quite the right direction.

The best if I attach the file.

So this is what it suppose to do:

1. There is a macro that imports data from MS project and puts it in the new worksheets that is based on worksheet named "Template". Those new worksheets are named 1,2,3,4...and so on, representing data by "Event" - stated in cell C4 of each 1,2,3,4.. worksheet.
2. Now, for each worksheet (Event) work is done to "Description, Lessons and Actions:" section, then entries ticked of in column J are transfered to "ACTION TRACKER" worksheet by clicking on Transfer button. (code in Module2).
3. Once transferred, entries will be modified in "ACTION TRACKER" and the main feature would be to mirror all those changes in orginal, source worksheets. Ideally if this could work both ways.

As for now transfer works ok, only data validation is lost.

PS
If anyone wants to undertake this task, and can help me in developing this tool further, I am willing to grant a bonus

Yes, that would do. One potential problem I see in this case, what would happen to all the entries that were not transferred in the first place? Maybe if we sort entries just before transferring putting them on top of the list? In this way number of rows would match.
The challenge form me now is a macro that would find the right worksheet to copy entries back Guess base on Event
In my mind it would scan through all tabs searching fo Event in C4 cell?