I have a master workbook with different sheets with different economic statistics. At the moment, I would go to a government website, download the latest data, copy/paste the latest row into my master spreadsheet. I do this 20 times for different statistics and it is very inefficient. Does anyone know of some alternatives to this? I was thinking of making a loop to go through my master sheet and match the headings with the government sheets and then paste the last row, however ill have issues with matching the correct date.

Does anyone have any tips to get me started on something like this?
Thanks