I am not sure if I understood, but try these to see if I did.
In F12:
=MID(TRIM(SUBSTITUTE(VLOOKUP(C11&"*",PC!$G$3:$G$20,1,0),C11,"")),2,3)
in B15:
=IFERROR(TRIM(INDEX(PC!$D$3:$D$114&" "&PC!$E$3:$E$114,MATCH("*"&$F$12&"*",PC!$A$3:$A$114,0)+ROWS($B$15:$B15))),"")
copied down
in D15:
=IF(B15="","",INDEX(PC!$B$3:$B$114,MATCH("*"&$F$12&"*",PC!$A$3:$A$114,0)+ROWS($B$15:$B15)))
copied down
Bookmarks