Oddsportal web scraper into excel

1. Scrape football odds from [login to view URL]: I have a spreadsheet which has past and upcoming fixtures for a number of leagues. When I open the spreadsheet it sets the date to "today" and lists all the fixtures for that day. I then have my own algorithm that will analyse all the statistics and create my own odds for a number of markets. In the cells in the row directly below my own odds I want to import the highest available odds for each of these markets and I would like this to update either a) each time I open the spreadsheet (and obviously am connected to the internet) or possibly b) each time I hit re-calculate (currently set to manual recalculation). All the country, league and team names in my spreadsheet appear in exactly the same format (spelling etc.) as they do on oddsportal. I have attached an example spreadsheet with a few fixtures from yesterday. Looking at the first example my odds calculations start in cell H3 running along to AB3 and I want the oddsportal odds for those markets to appear across cells H4 to AB4. I'd then want to copy this down for each match (4 showing here but on a busy day could be 50 or even 100). For the sake of clarity in column 1 I have put the identifier that appears at the end of the website url for each market. E.g. #1X2;3 is for the first half match odds market. In my heading: FH = First Half, SH = Second Half, FT = Full Time. H / D / A are equivalent to 1 / X / 2. Any number e.g. 0.5, 1.5 etc. = over that number of goals (e.g. FH 1.5 = over 1.5 goals in the first half). BTS (both teams to score) and 1.5, 2.5 and 3.5 are just the over markets for full time. 2. Scrape and update match results See attached sheet (data example). Self explanatory but can breakdown in more detail if necessary, want to automate collection of results and any adjustments to fixture schedule (if matches change date).