replacing certain values

This will be difficult to explain... I'll try my best:
I was creating a database, only to discover that the database was already partially completed by one of my coworkers. I decided to integrate the parts his database has with those that I have. So, here we go.
I have a spreadsheet that has a structure something like this

Please Login or Register  to view this content.

i stands for info, and m stands for missing. These are called missing because these data are not in my coworker's database. However, for any given row, I can be missing any of the data (for example, i1 and i3). His database always has all of the "i" parts for a given name. Names can be repeated, and perhaps most annoying is that his order of i2, i3, i4, and i5 is not always the same order as mine.
I would like to copy all of the rows that I do not have into my database. And if I have a very incomplete entry (say, only the name and i5), then replace my row with the row of my coworker's that matches in name and the available info.
So, I guess more simply, I want to make a spreadsheet with the most amount of information possible.
So, I was hoping for a macro that takes his spreadsheet and adds it to mine accordingly. Thanks. I know it's a lot of words, but I'll be happy to answer any questions.