Excel 2016 - looking for script to get data from password protected website

Dear Excel 2016 Wizards,

I am looking for a way to do the following via Excel Macro or other wizardry.

1. Login to a website that's password protected (I have username and password).
2. Download all raw data into Excel. There is information for 20 stores that I need downloaded into one workbook, different tab for each store.

I'm more than willing to share the website and password via PM.

Thank you.

On the "Data" tab of excel there is a wizard called "from Web"... this is designed for the purposes of importing data from the web ... have you looked at that ?

I've tried it and am not sure if it's the right way to go.