Creating a report with text data from multiple data sources

Thanks for quick response.
This is the replica of data I will be dealing with. Additional columns can appear, so the script has to take it into account.

When it's done, it should be able to lookup 50-60 companies and generate report for them from a database for about 500-800 companies.

NeedHelp.xlsx