Hello. My name is Raúl Fernández, I am an electrical power engineer, I know exactly what do you mean. I have a doctorate in information systems related to commercial and distribution electrical utilities.. Although as a freelancer I am a newbie, I have great experience in Excel, and of course VBA for its automation. For years I use both Visual Basic for Applications and Delphi, C ++ and Python/Django.
Yout proposition is very interesting and exciting and there are several possibilities with Python/Scrapy Excel,/VBA or a combination.
.I promise to work full time to achieve its purpose in the time indicated.