Need a formuila to add items marked as "yes"

Well the title says it all. I have a raw data tab with a list of clients (100s of rows). In another tab, i only want to create a list of clients that are marked as "yes" in the raw data tab.

I am for some reason not able to add attachments otherwise would attach one.

Edit:

Just to elaborate a bit further.

THere's a raw data tab with clients listed. I create a column marking certain client as "yes"

Now i want anotehr tab that will only show clients in the same alphabetical order that are marked as "yes"

There are several ways to do this:

Power Query
Pivot Table
Formula

For us to give you something that you can work with, I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"