How to transfer data from a web page to spreadsheet

Copper Contributor
Hello community,
I am still learning excel and am in need of suggestions. I am currently trying to transfer client data to a spreadsheet that will automatically refresh when I open up the sheet. However, this data come from PayPal and requires me to login w/password each time there to access the information.
Is it possible for me to still transfer this client data from PayPal to an Excel spreadsheet, and, is there a way to update it/refresh the information each day?
I've tried using the data tab in excel and clicking on the web page icon. I keep getting stuck when it tries to connect with PayPal.
Using windows 10 & Excel 365
Thank you.
1 Reply