Power Query Load data into Workbook but split onto different worksheets

[flyingmonkeyofdoom]

Does anyone know if it is possible to have your data and then when you load it back into the workbook it breaks the information down based on a column value?

The only way I can see to do is to reference the original data and select each location manually for each new query.
but I will have different locations when the data is ran

I currently use VBA to do the breakdown and was wondering if it could be done in power query?

Would I need to use M coding for it to loop and filter the location and add it as a new query?

Any help/advice on this is greatly appreciated