Power BI: How to import weekly data?

Hi all,

Currently I'm builing a Power BI Report for Engineering Progress Report data.

Regarding the Data: I get 5 Relevant Engineering Excel Files weekly. This Engineering data gets updated every week on Friday.

Now, the thing is from each of these Excel files I only need some tables or relevant information.

Eg: From Excel File 1: I need only 4 tables (and the other data (Many sheets) in the file is not required), and similarly with the other 4 Excel Files too.

How do I go ahead with data importing in my Power BI File? I mean do I have to always take it from the 5 separate Excel files manually? Or should I create one main Excel File by myself? How do I automate this process?

I would like my Power BI Report to be refreshed automatically when I receive the data every week as well.

Kindly request support on the matter. Thank you!