Auto Extract of Web data into Excel

Daily access to a website [login to view URL] and extract small tables of information (say 12 rows by 6 columns) to excel. currently done manually via data web page import. extract of data will occur at say 40 max times a day (ie. 10 times from 4 different spreadsheets) both morning and evening and will be determined by the times on the website and/or the table being populated or not with the data needed. sometimes data is not there until 30 mins after scheduled start time. Data is massaged in excel using find and replace eg remove apostrophe, remove a particular word in brackets etc, the concatenate function is used to remove a single space and a double space at the end of each final piece of web data extracted a list is produced in a particular sheet in each of the 4 spreadsheets and is sorted in order, but will need to be updated and again resorted throughout the day by the above staggered times vba macro is preferred so that can be easily transported