Reconcile two worksheets' data

[Apple08]

Hi all

I have to reconcile two worksheets' data, the first worksheet 'Master' has unknown number of columns and rows, the second worksheet 'Data' are with the same column headings from A to J as 'Master'. 'Data' worksheet is a set of update data which is for 'Master' to be updated. I need to compare 'Data' against 'Master' for the data within columns A to J. The data for column headings in red below are usually unchanged, therefore I have a thought to use concatenate or if formulas to put them together as an unique code for comparing. However you intelligent people may have better idea to help.

Expected Result: Master worksheet data will be automatically updated as per the Data worksheet. E.g. Unit 3 Group code, start and end dates will be updated to 123, 1/2/2020 and 31/12/2020 as per the data sheet. Also those updates in 'Data' sheet will be highlighted in yellow (I only change the text colour to yellow as I can't find the highlight function here)

Another example Unit 7 Stock in Master should be automatically updated to Y and the stock field for stock 7 will be highlighted in yellow.

Any help is appreciated. Many thanks in advance.

'Data' example:

Unit	Month	Group	Group Code	Type	Item Code	Item	Stock	Start Date	End Date
3	Feb	35	123	11	111	A	Y	1/02/2020	31/12/2020
7	Aug	6	134	12	122	B	Y	1/03/2020	31/12/2020
9	Sep	7	345	13	133	C	N	1/03/2020	31/12/2020
1	Jan	9	456	14	144	X	N	1/04/2020	31/12/2020

Master example

Unit	Month	Group	Group Code	Type	Item Code	Item	Stock	Start Date	End Date
3	Feb	35	124	11	111	A	Y	1/01/2020	11/12/2020
7	Aug	6	134	12	122	B	N	1/03/2020	31/12/2020
9	Sep	7	345	13	133	C	N	1/03/2020	31/12/2020
1	Jan	9	456	14	144	X	N	1/04/2020	31/12/2020

5	Feb	10	456	13	145	X	Y	1/5/20	31/12/2020
6	Mar	11	457	14	146	A	Y	1/6/20	31/12/2020