Youtube University is an awesome place but it takes time to find what you need. You will need to learn some VBA code of which there are tons of examples you can find with a simple search. I do not mind giving you some guidance. I have learned the hard way with VBA that it corrupts your workbooks if you are not extremely careful. I now keep my code on their own worksheets, I insert a module in VBA, then copy and paste my different code to run. Before I close the workbook I delete the code in the module then remove the module from the workbook. The other thing after you have saved your workbook go to the FORMULAS TAB, and click on NameManager. DELETE all items that do not say WORKBOOK under the SCOPE field. Depending on how many items you are deleting it can take a while to finish. If you do not do this you will end up with so many items in your Name Manager that are not being used that just make searching more difficult. It is a pain but I have not had to recover a workbook in a long time. Are you remotely familiar with excel at all? What version are you (Will you be) using. The other thing that is awesome is the Macro Recorder under the DEVELOPER TAB. It does add a lot of extra code to your macros but it is easy to clean up, and makes writing macro code much easier. Some web pages you will find are not the most Excel friendly but there are usually work arounds that once done you are pretty much set until they change the webpage. Post a link to a web page that has data you like and I will take a look at it and let you know what I think. The simpler the webpage the better. If there is a bunch of Java or other bs running it sometimes makes it impossible to get the data.
here are a couple of forums that are helpful for finding code help:
https://www.mrexcel.com/board/https://www.excelforum.com/ Also look up Web Scraping and a programming language Python