I have a load of excel files (consistent format, but with different content) that I would like to pull data from into one master file. All source files are saved on Sharepoint in one folder, and the destination file is also to be saved on Sharepoint.
I would like the master file to pull given fields from all files saved in the folder, without having to specify all of the file names.
I managed to get this working with Power Query for files just saved on my hard drive, but not sure the best way to achieve this same end on Sharepoint (using this method, for reference). Really nice solution but doesn't seem to be so simple via the cloud.