Conditionally merge data from two or more excel sheets

Question

I have 2 excel files with single sheet,there have same column name,one column name id is 'name'.I need to merge the second file data in the first file,and the 'name' row data in second file have to put the last row with the same 'name' row in the first file. How can I do it? Thanks in advance. first file second file final file