Search,compare,update,indicate data in excel sheet (macros VBA)

Q) 1 core excel sheet with 10 to 15 thousands rows and around 150 columns. Another targeted sheet to be completed with using VBA which content same 10-15 thousands row but selected 25- 30 columns.
Following operation must be done to get targeted sheet.

Button for performing below operation
Searching unique ID number from sheet2 to core sheet1.
Compare
If any change than update in sheet2
Color the update
Indicate the row which is updated


I will be really happy if some one help me to find out solution for the problem as early as possible.