Web scraping / Web crawler
Web scraping (also termed screen scraping, web data extraction or web harvesting) is a way to extract large amounts of data from websites and save it to a local file or database.
We can create a bot (a spider) using VBA/Python to crawl through website pages, gather the information you need and collect it in a database for further analysis.