So I am new here and just can NOT for the life of me figure out how to get this problem solved.

Situation I have a excel spread sheet that is formatted and can not be sorted *its a long story just stick with we cant sort it* We will call it Datasheet 1
Datasheet 1 looks some thing like this

Name Address Zip Code
Bob 10 dog lane 12528 2
Andrew 27 mike street 18987 1
Stue 44 big road 45872 2
Frank 1 my street 55555 3

I then am given on a regular basis other excel sheets that are very random some have zips some don't , some have company name instead of name. All sheets have at least a address and a Name * for this example company name is the same as name* in summary these other sheets that come in are not sorted and have varying field types with at least name and address.

What I need to do is have a Sub script I can save that will run the incoming sheets against datasheet1 find names that are on sheet2 but not datasheet1 and write those To a third results sheet. Here is a example keep in mind that the sheet named sheet2 is not the way it will all ways be formatted but it will all ways have name and address in column A and B respectively. One of the biggest issues is that because nothing is sorted or formatted I need to find a matching value from datasheet1 column A any where in sheet2 column A

Datasheet 1
Name Address Zip Code
Andrew 27 mike street 18987 1
Bob 10 dog lane 12528 2
Stue 44 big road 45872 2
Frank 1 my street 55555 3

Sheet 2
Name Address Zip
Kyle 15 dog lane 12528
Andrew 27 mike street 18987
Alfred 8 lake drive 87456
Stue 44 big road 45872
Patrick 11 dog lane 11111
Frank 1 my street 55555

Out put should look like this

Kyle 15 dog lane 12528
Alfred 8 lake drive 87456
Patrick 11 dog lane 11111

Please keep in mind that the excel sheets ill be using are HUGE with over 15000 records so I can not just run a loop to check each cell. I will try and attach some excel examples along with this post. * Keep in mind this has to be done with a macro/script because it needs to be shared to other users and run able on new sheets*