I am putting together a spreadsheet so I can manage some basic finances without needing to log into everything manually.

For example -- I'd like to be able to run a macro that opens up a web instance (ideally invisibly via Firefox), enters any relevant user/passwords required, and navigates to the desired pages and imports the relevant data that I can then process within my worksheets however I choose.

Any elucidation on the matter would be much appreciated. All I can seem to do is import the relevant pages but this assumes it's already logged on past the user/pass stage. I am not sure how I'd get it to actually "interact" with the pages I want.