Greetings Excelforum!

I am attempting to create a worksheet set that can synchronize data between each other asynchronously.
  • The data from Book1 is located in multiple sheets filled with first-input data.
  • The data in Book2 comes from the compilation of the data in all of the sheets in Book1 (Like, imported in batch copy/paste).
  • Changes are made in both books (rows inserted/deleted, cell data changed) that need to show on the other's.

I'm thinking of trying the use of macros, but I've never written any kind of sync script and am not sure where to start.

Example:
Book1
Sheet1
id,name,address,date seen, blah
Sheet2
id,name,address,date seen, blah
...
Book2
Compiled
id,name,address,date seen, blah
id,name,address,date seen, blah