Job has me doing a needlessly complicated task

My job has a SharePoint and on it there are individual docs for different sales reps to input their data and one master list of all of them (there’s 7).

My job wants me to have all the data from the individual sheets update into the master list. But I have never done that before and have been researching it and it’s just not practical the way I am doing it now. I downloaded all the spreadsheets from sharepoint, and finally got it so the formulas will work, the only problem is I have to do 1 at a time and I get a security notice every single time and then have to select the file again. I’m also not even sure if this will actually get it to update on the sharepoint.

I have brought up multiple times how there are 2 easier solutions. One being to add the individual sheets to the master sheet so I can add formulas in excel online or just have all the sales reps put in the same data in the master list.

I’m just really at a loss with this. Tried multiple solutions, tried using AI and no luck.

Edit: this has to be done early tomorrow