Selected Answer
Rick
Don't know which website you need but you may be able to loop through elements as I showed in my answer (to a question on the same video) earlier this year: Importing web data.
Alternatively, in Excel 365 you might be able use one of the few web tools. There's a command not shown on the Ribbon called "Get Data from Web" (put "web" in Search) which in theory lets you pick elements of a webpage (incluiding the lot). Also there's a query via the ribbon Data/GetData>/From Other Sources...>/From Web but to be honest I've had little success using either on sites of interest to me.
Hope this helps.