Solution to Merge Excel Sheets from Sharepoint library

[Omark]

Hello,

I am looking for some help. My situation

I have 17 excel sheets stored on SharePoint Online location (https:connect.xxx.com/sharepointlibrary)

The users will fill these sheets on and once they have filled it up. There are 10 users who would like to see the sheet which merges all this data.
How can we achieve this, is it possible to run a macro to merge all the files online.?

 

[Bernhardlip]

Did you ever get an answer? I have the same situation.