Display a range of results with "*"&A1&"*" condition

please see attached - any help to achieve the yellow area results

Both worksheets in reality are huge, and seperate files. I have explored an INDEX helper column and VLOOKUPs with no luck. I would prefer to avoid SUMPRODUCT as the spreadsheets really slow down.

Any help really appreciated :-)