Copy data from Sheet b to Sheet A, based on the existing contents of Sheet A using formula

Hi,
I have a question regarding Office Scripts in Excel Online, on how to conditionally copy data from one Sheet (Lets just Say Sheet A) to another sheet (Sheet B), if the value meets certain criteria in SheetB. For example:
Sheet A Columns : Name (name of the person) , Age (age of the person) , Fail/Pass (value will be either fail or pass)
Sheet B Columns: Name (name of person), Subject (Subject taken), score (value of the score of the subject)
I would like copy the name values from Sheet B to Sheet A, if the name already exists in Sheet A AND the Fail/Pass value in sheet A for the person is also Pass. Please do note that the name on sheet B can appear more than once and I would like to copy all of the values (Therefore for example if a person named "James" match the criteria from Sheet A, and "James" appeared in Sheet B 3 times, I want to copy all 3 instances of "James" as well as the subject and Score values from Sheet B to Sheet A

Any solutions is welcome (including formulas) or using Office Scripts, however, it must be implemented in excel online and therefore VBA/macros cannot be used.

This post is actually a duplicate of a previous thread posted in the VBA section of the forum, however, I think it needs to be posted here to because there may be solutions of the problem just by using regular formulas.
Awaiting your help, Thank you!