How To Compare Two Excel Sheets & Get Desired Result In Third Sheet!!

Hi All,
I have two excel sheets in one excel workbook and it has the following data. I like to compare them in such a way that if their "First Name" and "Last Name" Columns match then I need to get 3rd Columns (Instance & Device Columns) from both files in one file and ignore the names whose "First Name" and "Last Name" did not match

The only caveat I have is that "Last Name" column in one file has "hyphen -, Apostrophe' " AND other file does not have it but I need those names in my final file since they are exactly the same name its just one file has "hyphen -, Apostrophe" and other file does not have it.
I was thinking of making up a Unique key by picking up the name in the "First Name" Column + "first three letters" from Last Column

Enclosed file is attached with the sample Sheets
Sheet 1 & Sheet 2 has the data and Sheet 3 has the final result


I will really appreciate your help

Thanks

Also putting the sample in the thread itself

Sheet 1
FirstName LastName Instance
Ray Allen bic1
Steve Smith bic2
Ian MacDonald bic1
Jean DyeLand bic3
Mike Aaron bic3

Sheet 2

FirstName LastName Device
Ray Allen Computer
Steve Smith Laptop
Ian Mac-Donald Iphone
Jean Dye'Land Ipod
Tim Mark Samsung

Desired Result Sheet 3


FirstName LastName Instance Device
Ray Allen bic1 Computer
Steve Smith bic2 Laptop
Ian MacDonald bic1 Iphone
Jean DyeLand bic3 Ipod

Also putting the sample in the thread itself

Sheet 1
FirstName LastName Instance
Ray Allen bic1
Steve Smith bic2
Ian MacDonald bic1
Jean DyeLand bic3
Mike Aaron bic3

Sheet 2

FirstName LastName Device
Ray Allen Computer
Steve Smith Laptop
Ian Mac-Donald Iphone
Jean Dye'Land Ipod
Tim Mark Samsung

Desired Result Sheet 3


FirstName LastName Instance Device
Ray Allen bic1 Computer
Steve Smith bic2 Laptop
Ian MacDonald bic1 Iphone
Jean DyeLand bic3 Ipod