If you want to "automatically retrieve information from websites," then Web scraping is a useful tool. I originally used VBA for scraping, but it became overwhelmingly easier after switching to Python ...