Need Hep in Power Query

Hi,

I have a quarter wise excel sheet in sharepoint, the structure of file (i.e columns are not same) is different.

Want to bring this data in power bi and have to pivot some columns and perform calculation in  every excel file. Now, the requirement is set up the structure in such a way that the all calculations is done only once and then every quarter the data display dynamically.

I have checked the calcualtion is working fine individaully on  every file , I have even tried to append all the files but then also its a manual task to do calculations every time a new file is added in sharepoint.

So, my question is can we do something dynamic here instaed of manually adding file and then pivoting it and doing all calculations.

Please help me on this.

Thanks