Web scraping - improve my code

[kaseyleigh]

Hi

Is there a way to improve my code? Ideally, I'd like web scaping to be done within 1 x worksheet without the need to copy/paste in another worksheet.
I added comments in code

## From this point ...
## To this point

To indicate the section I am referring to.

Please Login or Register  to view this content.

Your time is very much appreciated - thank you!
Happy holidays!

[AB33]

All out put on sheet1

Please Login or Register  to view this content.

[kaseyleigh]

Thank you very much!