SharePoint folder

So, when you connect to SharePoint, you connect to everything you have access to. Just use the base file path name (no sub folders etc) should be like "sharepoint.com/teams/thissection"

Select > get data > More > Sharepoint.  A box should open up. enter the "sharepoint.com/teams/thissection" (whatever the base folder is titled). 

Search for your data (the name of the specific file)

Select your new table and click the Action button with the two down arrows. Search for the File you just created. Title should start with “WhateverFileYouWantToFind” Check the box next to your file name and then click OK. 

ADialouge box should open. 

You will then see the “combine files” box. Select your new table then click OK.   

Once the Query is loaded, title it “FWhateverFileYouWantToFind.” (Or whatever year you are uploading) by double clicking “Query 1.”  

Then close and apply. 

Repeat steps for each file. 

Best, 

Cam