Combine and append data from multiple excel files

Hi..

I have multiple excel files and data table in excel file as below. The file name is different each month and years.

How can I combine and append the data in Power BI. I try to avoid having the data staging files in excel format.

From excel perspective yes I manage to do it. However, there is a requirement to do it in Power BI ....

Anyone can help me on this ...

Regards,

NickzNickz