Google Spreadsheet Synchronize Two Sheets
I have 2 worksheets. Sheet1 and Sheet2
Now, have a look at the following script:
When you edit Cell A1 in either Sheet1 or Sheet2 then the above script will run the onEdit function, and Cell A1 on both the sheets that is Sheet1 and Sheet2 will automatically synchronize.
And If you are not much familiar with scripts then check out the following link:
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.