VBA Code to compare/match multiple columns in one sheet with multiple columns in another

Hello,

I have two sheets of data. One sheet has 12 columns, lets call it 'Outsiders'. The other sheet has 2 columns, we'll call that sheet 'Insiders'.

I want to compare the 2 columns of Insiders against the 12 columns of Outsiders and return a yes or no result in the third column of the Insiders sheet.

The Insiders sheet columns will have first name, last name or just Business name in the first column with a blank second column in those respective rows.

All the data is text and non-numeric. The idea is to check if an individual name/business name in the Insiders sheet shows up in any column in the Outsiders sheet and return a yes or no value in the Insiders sheet.

I am having some trouble trying to figure out the logic and code for how to do this. Any suggestions would be very much appreciative. Thanks.

This almost worked flawlessly. However, when I run the code, say there is a value (name) 'Jane' in the insiders list. The code returns yes, for values with 'jane' inside of them such as Janette. Is their anyway to have it return yes only if the exact name is matched not just the first couple of characters?
Would it also be possible to return the cell or cells in the insider sheet of the matches from the outsider sheet. For example, column 3 of the insider sheet would read 'yes' and then 'A,4'. Thanks.