Hello,
I am a skilled software developer and I can automate at least some of this work for you. Python is a very good programming language and I am quite confident I can do this task up to your expectations. While a fully automated solution might not be feasible, I can still speed this process up by quite a bit. Polishing the data shall be done by hand :)
Please contact me for further details.
Thank you,
Alexandru