Multi-Search Code

Hey guys, I have a request, and I'm planning on putting it on Commercial Services forum. I want to get an idea of what is a fair price to award for completion.

I have a master tab. It has 15 columns. Each column pulls data from other tabs. I need a search button that allows users to search for one of 5 columns.

Once the 5 columns have been searched, each match should populate with all the info that corresponds to that ID (the rest of the row).

Then, and here's the hard part, I need the search function to comb through 3 of those columns and find any new matches to the original matches. Essentially, it goes like this:

Example: James (column 1), who is 21 years old (column 2), is green (column 3), and loves pizza (column 4).

I only know that I want info on James, but don't know that he is 21, green, and loves pizza. So I type in james in the search bar.

All of the data (james, 21 yo, green, pizza) should pop up in a new tab. Then, the search should automatically look for all other people who are either 21, OR green, OR love pizza, because I want to introduce James to them.

Add'l Notes:
- Sometimes there may be 5 james who are 21, green, but love a different food.
- Case (upper vs lower) can't matter in the search (james should work as well as James).

1. Are you sure this would give me all the links I need? I'm worried if I put James in as the name, only fields with James would populate. I actually need all the fields that are the same as james info (21, green, pizza) as well.
2. Would an average corporate worker be able to run a search via MS Query with limited instructions?
3. Do I need to download MS Query, or is it already in Excel 2010?

Thanks!

@alansidman, The problem is that the users won't know that James is 21, green, and likes pizza. They just know that they want a James, and anybody else who is like him.

I've attached an example (with my failed code embedded). The highlights on the second tab are what should be matched via the search criteria.VBA Template.xlsm

Your initial search.... will it always be by name? Or other columns? And if other columns, you are always looking for the first result matching that search to key off the other 3 searches? - It can be by any of four columns, but if necessary, can make it by 1 name/ID. I would indeed always want the first search to kick off the other matches.

Sounds like a two stage task. Input a name, get his information then use that to search for like minded people. Would it be a 100% match or a partial match? - It would be a partial match. If someone likes pizza, but is different age and color, we still want to know about them.