Find value in a cell in different sheets and copy and paste other cells to another sheet

Hi,

I'm just a beginner in Excel Macro, and I really need some help, that's about two days that I'm struggling with this problem.
I have 3 sheets containing information, and I would like to copy some of the information they content if a condition is met to a report sheet. I have a list of contact in the 3 different sheets with different information; in one phone number, the other one the address and the last one a job. In my report sheet i would like to create a macro which when you select the first name Paul and you click on the button next to it you would have a list of the corresponding information about the different Paul which are Blond (if the result in the column Blond in the different sheet is Yes) in the different sheet. Plus I would like that in the report Sheet column Type the name of the sheet containing the information where they were taken appears.

I don't know if it's clear enough, I join a excel file.

Thanks a lot !

A couple issues that I need to point out.
1. Which sheet is the report sheet? I see Phone Number, Address, & Sheet3
2. Where are the buttons you mention? I don't see any buttons anywhere in the workbook
3. Where is this Paul, or blond you mention? I don't see anything like that.

What I'm getting at is, you say:

i would like to create a macro which when you select the first name Paul and you click on the button next to it you would have a list of the corresponding information about the different Paul which are Blond

, you don't want to do all this, you want someone here to do all this for you, is that right?

I don't know if you've thought of using filters or not, but they don't require code and they may be what you need. See Here for filters.

Hi the-hawk,

One more thing I'll need from you. I need you to set up exactly how the report sheet should look after the "Find all people named" is clicked and then re-upload that version of the workbook. Once you do that, this should be a relatively easy fix.

That's good the-hawk but I need to know which fields are coming from which sheet. For instance, Sheet Job has a Ref Number that is different from Address and Address Ref Number is different from Phone Number. What I was hoping for in your last upload was which data was going into the Report sheet.

As for the format of the Report sheet, we'll be able to handle that after.