Daily Web Data Gathering

A maximum of two hours work each day - on-going subject to quality of work and accuracy. Requires selecting web pages one by one, highlighting a table for each page and retrieve the daily data and place sequentially in a spreadsheet, then edit (tidy up) the results, perform some simple calculations in the spreadsheet and email the results before a certain time each day to me. So for each table - enter a table identifier description in the spreadsheet, then drag cursor at beginning of table line 1 to a position at the end of table last line, right click and copy the contents and paste as text sequentially in an excel spreadsheet. When all tables scraped and pasted, delete unwanted columns in the spreadsheet, tidy up the remaining columns, perform some simple calculations and then email the spreadsheet with a filename of "DailyScrapeYYYYMMDD" to me. Simple If this could be automated I would also be interested. There could be other daily admin requirement.