read from excel data and search to another excel data

I have several excel files that has data of Lastname, Firstname, Middile Initial. I have also an excel file that contains the lastname, firstname and middlename. I would like to search and replace the several files for first namg and lastname using the data on the second excel file then replace the middle initial to middle name. This is an easy project for the one who knows excel macro of vb.