Generating an agenda?

Hi! Sorry in advance if this post makes no sense or if I've posted in the wrong place. I'm new, and terrible with Excel (except with basics).

I would like to know if it is possible to do the following.... I have a basic worksheet with people from my team filling in rows to say what projects they are working on and some basic project details.

A column in this sheet says "AGENDA ITEM?" and they select yes or no (basically, if they would like it to be put on the agenda to discuss at the next team meeting).

In a perfect world, I would like to be able to have another sheet which looks up all of the projects containing "YES" in the "Agenda item" column and generates its own agenda by pulling through the titles of the projects associated with them, and the owners.

...............I hope that makes sense. And so, is it possible?

Many thanks in advance!

Hi Tony. Thanks for your reply! I think it looks like that might be very similar, if not the same, as what I am trying to do. Let me play around with it for a while (it will probably take me a little bit of time to get my head round the individual elements of the formula!) and I will get back to you and let you know if it works.

Thanks for your help Tony! It worked.