How to combine multiple rows of data into one row and then add text in between from another data set using an arrayformula?

I have 2 data sets with non-exact matches so I can't use a simple vlookup or even a vlookup with a wildcard.

Here's a visual of the data and the desired result: https://docs.google.com/spreadsheets/d/1TB8NtedUpehmsRG1-NJ0RzvfopFu9PlsgcOVfrUorzA/edit?usp=sharing