Pulling data from company website that requires username and password

Hi,

Is it possible to pull data from a company's internal website that first requires a username and password? After I log into the page, I have to run a querying tool that pulls up data based on several metrics and categories I selected. I'm just trying to figure out if it is a possibility to automate this using a macro. I have used Legacy Web on excel to pull up a URL page, but I have never used it to pull data from a website requiring a username and password and then subsequently needing to select a different page once in that website.

Any insight would be appreciated!