Hi Jindon,

Thanks for this code, it resolves one part of my requirement.. I'm having multiple people work the same data as master sheet and required to consolidate the changes and add new data (row) to master sheet.

i require below changes in the above code. If you help me with that really appreciated.

1. There'll will multiple sheets similar to sheet1 (Master) (will run a separate macros to consolidate the worksheet from diff workbook saved in the location - good if you add that also)
2. Macro need to compare the data in each sheet with Master and move the changed row from other sheets to "Update" sheet with last column as sheet name
3. Highlight the duplicate rows (Unique ID) in the update sheet and ask the user to fix the duplicate
4. Next macro to update the master with "Update" sheet. First check for duplicate in Update sheet and not proceed further until the duplicates are fixed
5. Wish to have command buttons (consolidate, Check, Update) in the first sheet to perform the above actions ne by one