Not sure exactly how to explain this correctly but I have build an excel model that was derived from data from multiple excel files that were downloaded from a website. It is a simulation that continuously updates the data each hour. Is there a way to link the cells in excel to the data hosted on the website? I have done it by updating certain elements of a webpage but these are download buttons that trigger the download of an excel file. There are about 20 of them that I have to keep clicking and downloading and then open each individual one, copy and paste into my main sheet. Also the site requires a login so I would suspect this has to be built in. If there is some functionality in excel that would allow for this any help would be greatly appreciated! Sorry if that wasn't explained as eloquently as it could have been.

Thought there might be an easier way.

Thanks!!!

Vivian