VBA to extract data from multiple files in a folder

[Colleen1213]

Hi All,
I'm working with a code to extract data from multiple files in a folder, which was posted by Jerry Beaucaire (also pasted below) here: https://sites.google.com/a/madrocke.../merge-functions/consolidate-wbs-to-one-sheet
I'm wondering if this code would work with Sharepoint files? If so, would I replace the filepaths that currently point to the local drive with the filepaths to the sharepoint websites? Thank you for any assistance you can provide!
Colleen