link a cell in "Edit" mode


A have a source sheet from which I am linking cells to the destination sheet. The later sheet is currently in "View" mode only. Does any one have an idea on how I can link cells in different sheets and be able to edit them in both source and destination sheet?

Or, if anyone has other suggestions for a similar function that allows me to link sheets and edit them as the same time.

Many thanks,