Gather data from other workbooks (on sharepoint) into central workbook

[abssorb]

In a single sharepoint folder there is a bunch of workbooks which are reports, all using the exact same template, but with different file names. The files are replaced with a new version once a month (no guarantee filename will be the same as last month). The template can be revised.


I want to extract pieces of data from each of the reports and consolidate into a single workbook.


Probably VBA, but where should I start? Any tips or links most welcome.

(This is for a corporate environment, so no plugins allowed unfortunately, and there is no webdav)