Sharepoint Excel Files

I have case where I have a sharepoint site where multiple excel files are located as attachments. These files are put in on a regular basis.

I want to pull in data from all these excel files located in sharepoint and combine them into a single excel file on my local machine. How can I achieve that? Is there a way we can do this?