Index & Array Formula

For column B

=IFERROR(INDEX(Sheet1!$B$2:$B$12,SMALL(IF(Sheet1!$A$2:$A$12=Master!$A2,ROW(Sheet1!$A$2:$A$12),""),COUNTIF($A$2:$A2,$A2))-ROW($A$2)+1),"")

For column C

=IFERROR(INDEX(Sheet2!$B$2:$B$12,SMALL(IF(Sheet2!$A$2:$A$12=Master!$A2,ROW(Sheet2!$A$2:$A$12),""),COUNTIF($A$2:$A2,$A2))-ROW($A$2)+1),"")

ARRAY formula is used

To enter ARRAY formula
Paste the formula
Press F2
Press Ctrl+Shift+Enter keys together.

Both of the answers worked. thank you so much for the prompt reply!