How to streamline Power Query report.

Hi, I have. Abasic understanding of PowerPoint Query and am looking for some guidance that will streamline a report I create. Right now I download2 excel files that I upload to PQ to merge the relevant data into 3rd report that I can distribute.

I'm currently moving the 2 reports from the download folder into a 3rd reporting folder. Then I open up the excel file I have and open the PQ editor and go to the report 1 and double click the source and replace it with the new excel report I just downloaded and then I repeat this for the 2nd report. Then I let PQ do its thing to create the merged report. I do this weekly.

Here are is what I want to accomplish.

1. Can I auto upload the 2 reports from the reporting folder into excel/PQ rather than manually uploading them and how?

2. Can I retain the old report data so I can show week over week changes?

Thanks.