HI, Matt S Rinc here and after 20 years of software development I can certainly help you.
But do please provide more information, please:
1. Sample HTML pages you need converted (are they from the same site and/or have the same structure, what part of their content you need to have converted etc).
2. Where should the content be converted - automatically each day to a new Excel file, saved to your web hosting and sent as a link or attachment to your e-mail address?
3. What reporting and charts do you expect? Do you mean after the content is fetched it should be not only put into cells of created Excel document but also turned to graphs? This should be exactly specified before continuing (and me accepting this job).
Looking forward to your reply. Based on the amount of work I hope that your budget will be enough.
Regards,
Matt