Forum Discussion
Help on Combining Data from Multiple Worksheets into a Single Worksheet in Excel
If monthly sheets have the same structure you may collect them in separate folder and use File->From Folder connector. It combines data from all such files, you may return summary table to Excel. But better load to data model only and build pivot tables / charts from it.
My monthly sheets have the exact same information and structure each time. So if I have them in a separate folder and use file>from folder connector, can I continue to add months to it in the future and it still combine the data correctly?
Yes, you may add / remove files when needed. You may start from two-three sample files to see how it works. On first step you'll see list of all files, click on Combine Files button on Content column and follow the wizard, make other transformations if necessary.