Help with setting up the path

Hello!

I am totally new to the Power Bi but I have hard time to set this up..so..I have a folder with a one excel workbook, I imported this workbook (1 sheet) to the Power Bi and before I start tranforming, shaping the data and creating a report, I wouls like to create and set up the correct path so that every week, month when I add a new sheet to that folder (it will be added every 3 weeks), I will be able to open the report , click refresh and all the new sheets will be automatically transformed and added to my report.  Can someone help me with this please?

I hope this is easy to follow. Thank you in advance!