Copy data from across multiple worksheets using conditionals

[chess13man]

I created a database using excel in which every time a marketing project is run I follow a series of metrics. The form is exactly the same for every technology. I am trying to determine a way to run a VBA or ideally a formula like vlookup to search all the worksheets and copy the data to another worksheet if specific conditions are met

As you can see in the attached worksheet I have three worksheets with contacts. I want to pull only the contacts that have a yes in the follow up column into sheet 4.

[mrjinx007]

Is this what you need?

[chess13man]

I don't think this is what I need. It looks like what you did only looks at one worksheet. What I am trying to do is have the function search all the worksheets and pull all the cases in which the need to follow up is a yes. Am I interpreting correctly?

Thanks