EXCEL to download files from Internet and then append them all into one

I have a list of URLs in an Excel sheet, say A1, A2, A3 of say Sheet1 & so on from where I need to download ZIP files (one ZIP file against each URL), number of URLs in my list is in the range of 300 to 350 (say upto A300 to A350 or so).

I need to have a macro for Excel to download file from each of these URLs one after the other and save it in a folder, say 'Downloads' folder; post which I will manually extract files in the same folder from these ZIP files & then delete these ZIP files, post this I would like to run another VBA whcih will open these CSV files one-by-one and append it in the Excel Sheet (say Sheet2).

Please notet that all such CSV files are in same format with same headings so can be appended just one-after the other.

Kindly assist in developing such 2 VBA codes.

Thanks for your support in advance