Splitting a large data souce Excel into few smaller excel

Hi stevelam9569 

No worries at all mate.  Firstly, here are a couple of links for you to look at:

• https://powerbi.tips/2016/06/loading-data-from-folder/
• https://docs.microsoft.com/en-us/power-query/connectors/folder (just go down to the subtitle "Connect to a folder from Power Query Desktop" and read up on the steps.

Alright, now to answer a few of your questions with answers (or additional questions lol):

1. With regard to the five sheets in your Excel file, are they the identical structure?  Or is each sheet unique and for a different purpose?
2. I believe that because you are changing the data source from a single source to a folder as source, you will likely need to do a bit of rework.
3. Regarding all of the new Excel files each month, all you will need to do is literally save the Excel file down (with the same headers, etc.) to the folder that you are using as a source.  Then all you need to do once you save the file in the folder is go and press the refresh button. And that's it.

Let me know if that makes sense or if you need further clarification.

Theo 🙂