Hello!
I am experienced in making software like this and I mostly use Python 2.7 with BeautifulSoup and regular expressions for parsing the web pages. I can either make the program dump the resulting data in a csv file, which can be easily imported into Excel or other programs, or I can make it dump the data into an Excel sheet directly. Depending on the amount of data the script needs to collect and the difficulty of obtaining the data, I can use other libraries. If you are interested in my approach, feel free to contact me so we can discuss the details and so I can try scraping the public sources you mentioned.
Cheers!