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.