Combining data from multiple sheets to Master and Update

Hi everyone

Hope someone can help and is up for somewhat a challenge.

I have an incident log that contains multiple sheets. I would like a button macro (or a number of them) to do the following

1) data from multiple sheets to merge to the Master
2) as additions are made to the individual sheets ie a new row of actions, would like only the additions to be copied over (to avoid duplicates in the Master)
3) changes made to an existing record in a sheet, such as priority for a row has changed, that to update on the master and highlight that there was a change (until the next update), for an example if the status changed from In progress to complete highlight on next update only

alternative is to have changes made to reflect on the Master but a audit log of changes is retained, ie sheet, date of change, what fields changed, what the cell changed from and to

Many thanks

Tams