Pull data to new tab if matching certain criteria

Thank you for taking the time to help me with this issue. I have a grid that I have attached. There are a number of "Benefits" listed in column A on the tab labeled "Master". Than I show each of the US states starting in column P through column BN. Each state says "Yes" or "No" for each corresponding benefit. What I need to do is create a new tab (labeled "All Benefits") and use some type of formula that will show all the "Benefits" in column A and than only pull ONLY the states that have "Yes" listed for each benefit. So for example, in the attachment, the first state listed in the Master tab, is Column P and is the state of Alabama (AL). As you can see, they have "Yes" listed for every benefit in column A. Therefore I would want to pull the entire column of P in the second tab. However, column Q on the Master tab is for the state of Arkansas (AK) and they have some "No" entries, therefore that state would not be pulled into the second tab.

Something else to consider is: Ultimately I will be adding more tabs that will aim to pull the states that have "Yes" for a few of the benefits but not all of them. So for example, maybe the third tab I create will be for only the first five benefits from Column A (Missed Connection, Travel Delay, Baggage and Person Effects, Baggage Delay, and Non-Medical Emergency Evacuation). Therefore I would only want to pull the states that show "Yes" for these 5 benefits. So ideally I would like the formula to be able to be customized where I can adjust it to pull the states that match whatever benefits I am looking for.

If you have any questions or concerns please do not hesitate to post a reply. I really appreciate anyone providing some help with this.

Thank you.

-Garrett