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!