scrape multiple pages same url

[fastballfreddy]

Hi,

I've hit a brick wall trying to figure out a code and need help. I have a code that can grab the data from webpage I need but there are multiple pages and unfortunately it's the same url for each page. I googled and searched and even tried power query but that only shows the first table. any thoughts/help to lead me in the right direction is greatly appreciated. If only each page had a different url no problem.

 

[Anthony47]

Maybe we can succede using Chrome and Selenium driver; see extract data from web to inside sheet without open website &refersh
But anyway this require accessing the web site to analyze its html source code, so first share its url and explain which data should be imported