I have to update the master excel sheet which has more than 80, 000 rows based on the individual sheets. The VBA code should help me to check the data present in A and B columns of both master sheet and individual sheets. If it matches, vba code should copy the remaining rows (C to M) from individual sheet and paste it in exactly the matched data of master sheet.

Example

Master sheet
A B C D E
Data 1 10
Data 2 15

Individual sheet



A B C D E
Data 1 10 a b c
Data 3 20


once you run the code


master sheet should become


A B C D E
Data 1 10 a b c
Data 2 15



Please guide me to make this VBA code.

Thanks in advance