Forum Discussion
Help on Combining Data from Multiple Worksheets into a Single Worksheet in Excel
Hi, I have this spreadsheet that I am working on and it contains multiple worksheets of data. I would like to combine all that data into one and create PivotTables out of them. I would also like to ...
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?