I would like to scrape the data from the search results of a website using VBA

I would like to scrape the search results of a website. It should output the result into an excel file. It needs to do the scraping through VBA programming. I require the source file.

I will provide a document with all the search terms I want to be used.

I will do the scraping. You just need to provide the working VBA code.