Excel Queries with websites

I am trying to pull data from a website, but the table only shows 50 values at once. There is an option to expand this to show all at once, but it does not change the URL so I can't figure out how to...