WEB scraping and data parsing

I am looking for a way to automate a web scraping activity. I have to manually find every company name I have to find the information I need on the database. I want to find a solution to automate the research process of every individual company I have to find and the data extraction of all the informations available on the web page and stack it properly to use into PowerQuery and Excel.