Named range data and macro input

I have come across a site with financials and I want to enter them in an excel spreadsheet. The problem is that the site is password protected and I need assistance to copy the data with macro transfer from the data sheet to the template sheet. I believe a named range would be the best approach and I have researched on the same with no success. Help me in naming the financials that would be used in the template. I will also need help in recording a macro that can run for every new company analyzed. Help me on this