Get Data From Web

[Deleted]

I'm trying to get data from the web which has multiple pages- however when it only recognizes the first page. It won't let me go to the other pages- it ends up freezing. I've been trying to do this as a macro as we want to create a live connection between the online information and a spreadsheet, is there any way around this?

Thanks in advance!