combining multiple excel files from nested folders on onedrive

Question

Is there a way to make a combined "master" Excel file from multiple individual excel files inside multiple folders on OneDrive? Each project has its own scheduling file and I am wanting to automatically pull that information into a master scheduling file. An example path for the Excel file is stored is shown below. All the headings in the Excel file are the same

ex: Projects\Addresses\City\HouseAddress\Forms\scheduling.xlsx

Answer 1

Dear Lepley,

Greetings! Thank you for posting in the Microsoft forum.

You can achieve this requirement in Excel for the web if all the workbooks (source and destination file) are stored in either OneDrive or SharePoint.

To create a new Workbook Link, follow these simple steps:

1. Open two workbooks in Excel for the web. They should be stored in either OneDrive or SharePoint.
2. In the source workbook, copy the range.
3. In the destination workbook, “paste links” via the right click menu or via paste special on the Home tab.

For detailed instructions, see Workbook links in Excel for the web

If you need any help, let me know, I will be happy to assist further. We will look forward to your reply. Stay safe and stay healthy.

Sincerely,

Neha Singh | Microsoft Community Moderator