Auto download web csv file and copy data into Excel tab

[laborday05]

Hello everyone, thanks in advance for your help and support. I am not a VBA expert so I am looking to you all for your expertise. I am wanting to see if it is possible to automate downloading a csv file from a public website and have the data copied to a specific location in excel. The site populates a new file every hour and I would want to select the most recent file available when I run the task. The location of the files are at ERCOT MIS.

The csv. zip file at the top would be the one I want to pull from.

Any help is very appreciated. Thank you Excel Experts!