Guidance on extracting data from an website protected by password [closed]

I am a beginner programmer and am looking for some guidance on how to automate the following task:

1. I first, login with a username and password, which I have access to
2. Then, I get directed to a different web page on the same website, and after a series of clicks, I get redirected to a page that will allow me to download an excel sheet
3. After clicking a download icon, an excel sheet will download to my local computer, a different one each time I download
4. I take this new excel data and add it to my existing excel sheet on my local computer

Thus far, I've used python module BeautifulSoup to login to the page but haven't had much success. I also tried downloading the data directly "from web" in Excel, but that doesn't seem to work either.

The task maybe not be trivial, but as I am a beginner, I have no idea where to start. Any guidance on what tools to use as well as advice from someone who as done something similar to this before would be much appreciated.