Excel Lookup to Website you log into.

HI
I'm wanting to create a tool within excel that will take a list of data and lookup a secure website, bringing back values from said website.

As the website is a 2FA portal, there will need to be a pause built into the macro that can then restart once the website is logged into. Doesn't matter on browser as works on both Chrome and Edge.
Any ideas?

Caveat - I'm a bit of a luddite when it comes to macros.