Web Table Numbers to Excel

I have a series of webpages that display numerical figures neatly arranged in HTML tables. I need those numbers captured and transferred into a single Excel workbook, one worksheet per page, then organised so the file is ready for reporting.

Here’s what I expect:
• Every table reproduced faithfully in Excel, preserving the original row / column order.
• Clear, descriptive headers on each sheet and a brief summary row or section where you total or average the key figures (depending on what the table shows).
• Consistent number formatting so the file reads cleanly when printed or shared.

No text paragraphs or mixed content—only the numeric values matter. Accuracy is more important than speed, but I’d still like a quick turnaround if possible. If you’re comfortable scraping or copying data from web tables and laying it out in a professional-looking report format, this should be a straightforward task.