Can I combine multiple worksheets in a folder to a massive worksheet?

[Knockoutpie]

I have a worksheet that I update frequently that's a compilation of my weekly works. The issue is sometimes I forget to update it after a while and it's a ton of work..

Is there an easy way to combine all my weekly worksheets and combine them on one very long sheet?

folder path:
C:\Users\knockoutpie\Documents\Reports\POS - Brand

I would like everything to be compiled into my report called "Master Report"

Would there be a way to do this automatically every week a new report is created?

I will continue to do my research, but figured i'd also ask here.

 

[alansidman]

Power query combine worksheets - Google Search