You will need to first read the data from Excel. To do that, use Launch Excel to open the file. Then Get first free column/row from Excel worksheet to get the relevant range (unless you know it will always be 80 rows, in which case you can hard-code that). Then use Read from Excel worksheet to read the data. Make it read a range from column A, row 1 through column B row %FirstFreeRow-1% (from the previous step). Then use Close Excel to close it, as you won't need it any further.
Now that you've got your data in a variable (data table), you can use a loop, such as a For each to download those files. If the target files are not protected by any kind of an authentication mechanism, you may be able to simply use Download from web action and pass the URL into that. If you do need to authenticate against the server, you will need to launch a browser first and use the web UI to download the file.
You can watch this tutorial which covers the part of reading data from Excel and then passing it to a web page: https://www.youtube.com/watch?v=1WezrCQlpBY&ab_channel=AndersJensen
This article also covers it to some extent: https://www.matthewdevaney.com/power-automate-desktop-data-entry-from-excel-to-website/
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
