I usually use the solution introduced in this blog (Scrape Data from Multiple Web Pages with Power Query) to get data from multiple web pages. You can transform the successful query into a custom function with a page number parameter. Before that I recommend that you edit the URL in Advanced Editor to do a test to check whether you can get data from other pages by only modifying the URL in the successful query.
In below screen, select the base url without page number param in "Select which level to apply these settings to" dropdown box. Keep using Anonymous type.
Best Regards, Community Support Team _ Jing If this post helps, please Accept it as Solution to help other members find it.