Cell critera met in one cell, copy information two other cells unto another worksheet

Hello, Please accept apologies that my first post is a question.
But I have been working on a multi sheet spread sheet and this last part has me stumpted.

on my sheet labled "List of Clients" H9:H109 has a drop down list that has the choice of "Yes" or "No".
When "Yes" is selected, I require that their phone number (A9:A109) CaregiverName (B9:B109) and Client Name (C9:C109) be displayed in a seperate sheet labeled "Info & Schedule" in B22:B34 , C22:C34, D22:D43.

I will attach the spreadsheet so that you may get a better idea of what it is I am trying to convey.
I appreciate any help that anyone could do for me.

The easiest way I can think of is to make a Pivot Table with active filter on the "Yes" "No" field. You will need to refresh each time you make changes.

Please see the attached.

I am not sure if you know how Pivot Tables work or not, but it will automatically create extra lines for each value, so if your entire sheet is yes that is all you'll get. You will also be able to reduce it down to specific care givers by clicking on the filter button and selecting a specific name.

Let me know how you get on.

Thanks for your response. I had also thought of that as well unfortunatly, I require the information to populate on a different worksheet. If that is possible then great. But I believe that pivot tables response is on sheet of the array you are working with.

Not with a Name reference and as long as you have the full file storage path in place.

I have just tested it and it will work on a separate workbook, the only thing that has to be in place is that the source path for the Pivot Table is not changed.

I will try that and let you know how I make out. I didn't realize that was even possible. Thanks