I asked a similar question on the Google Support Forum. I was wondering how I could reference a cell with any sort of value in it to another sheet (inside the same Google Sheets document) and then make it so I could edit the reference cell and have it edit the original cell as well.
You can already edit the original cell and see the updates on the reference cell. But how could I have it work the other way around? I am aware that I would need a script, so could anyone help with such a script?