Improving existing VBA code that scrapes 6 websites

I have 6 macros that scape data from 6 different websites (the codes direct the websites in what data to display and then loop through different dates and inputs - which have been driven by different excel spreadsheets. The output is to an excel spreadsheet. The code needs to be improved to better handle errors (website timeouts, no data available etc) and then re-run to capture without intervention. In addition, I would like to scrape data from another two new websites and include in the final solution. Please reply if you have experience in web scraping using Excel, with completed projects (JQuery experience also required). Please Do Not reply if you have a poor completion rate, or are too busy with other projects and cannot complete on time. Timing. I will award the project in 24 hours time, and would like it completed in the next 7 days, with regular progress reports. Many thanks