I. Hola Agustín, por mi parte no soy conocedor de Excel sólo lector de la comunidad pero deseaba trasladarle la información que vi sobre su consulta por si pudiese serle de alguna utilidad mientras le atiende una persona conocedora de primera mano. Le ruego me disculpe todas las molestias de lectura y la imprecisión, ánimo.
https://stackoverflow.com/questions/60701823/scrape-data-from-list-of-websites
https://stackoverflow.com/questions/54263918/search-a-website-with-excel-data-to-extract-results-and-then-loop
https://nanonets.com/blog/scrape-data-from-website-to-excel/
https://foro.todoexcel.com/threads/consultas-para-realizar-web-scraping-con-datos-desde-una-web.61054/
https://forum.uipath.com/t/scrapping-the-web-for-the-information-based-on-the-user-input-field-invoice-number-etc/494712
https://www.octoparse.com/blog/scraping-data-from-website-to-excel
https://stackoverflow.com/questions/54263918/search-a-website-with-excel-data-to-extract-results-and-then-loop
https://stackoverflow.com/questions/36559520/how-can-i-scrape-product-name-and-pricing-data-from-an-online-retailers-webpage
https://www.youtube.com/watch?v=uDlnhn1K9Rc
https://www.youtube.com/watch?v=LdSBlzEqBok
https://www.youtube.com/watch?v=7XHciUCJrFs
https://www.youtube.com/watch?v=lFx0MkyBZsg
https://www.facebook.com/watch/live/?ref=watch_permalink&v=2694868693992208
https://www.youtube.com/watch?v=J86ck64WM8A