We can scrape any data from a web site into Excel file. It can be simple data scraping. e.g. when we just loop all directory pages and extract all names and emails, or it can be complex process when macro should log in, enter data into multiple fields, click buttons, open pop-up windows, extract specific data (include tables, images, files), parse data strings etc.
Scraped data sample: