Macro to update cells in one document based on another identical document?

[tonywatsonhelp]

Hi Everyone,

I have an idea and want to know if anyone help me with it or give me a better way to do it.

I have a document that has 4 sheets
Data1
Capacity1
Sales1
Sold out1

(there are other sheets in the doc but these are the important ones.)

Now the problem I have is this document called "Sales Records" holds lots of macros that need to run all the time.
however I need more than one person to be able to use it at the same time.

So I was wondering if I could create a copy or two and use a macro to imput the changes done in the copy into the main document?

so heres what I was thinking.

Sales Record Main is the master
Sales Record1 is a copy

when the macro is run it looks at Sales Record Main sheets
Data1
Capacity1
Sales1
Sold out1
and compares them to
Sales Record1 sheets
Data1
Capacity1
Sales1
Sold out1

if any data in Sales record Main is different it updates it with the data from sales record1

any ideas how I could do this, if it would work and if there is a beter way to do it?

thanks

Tony