If you create the forms on your computer, you can then host them on sharepoint. If you then open both the form and the desired location for the data from sharepoint, you can reference the cells which will grab the data from the form on sharepoint. You can use the online location in the same way as a filepath on your computer.


For example:

In the past month i have hosted our budgets onto sharepoint. Each of our branches has to submit a weekly report using a template, which is now hosted online. When they go onto the sheet, they update the links and it pulls the budget data for the respective branch from its sharepoint location.

We then have a group report which is now also hosted online, which pulls the data from each individual sites reports.