I have this Excel report that I have to download for work every week and once it's downloaded, I add it to a Master file that I have as an additional tab. To download the report, I open up the report itself, I just go to my work home page and it's a few clicks from there to download the report.

What I am trying to do is to automate this somehow - What I am thinking is another tab on my Master report with a button that I can click and have Excel automatically download the report and add it to another tab in my master file.

One more thing - I checked the shortcut to the file that I download and the hyperlink changes every week - so this week's link is www.xyz.com/file1_05072022.xlsx and next weeks link will be www.xyz.com/file1_05142022.xlsx