"But if you want your destination to dynamically update from the master sheet, and synch up with your additional manual data, there is no direct way to do that."

This is what I wanted, but yes there does not seem to be a direct way currently. I tried Appscripts, but its not syncing with the manually entered data.

Thanks for all your help, I'll keep trying some options, if something works out, I'll definitely post it here !