Capture URL's from competitor website into Excel

I have a spreadsheet with 3775 part numbers in it, that I need entering into a competitors website catalogue, and retrieving the URL.

https://theslshop-my.sharepoint.com/:x:/p/jack/Edytz1dhBtNIsvc_eFxuVegBcAU0hEjAiXU1iCUvaDhKuQ?e=NmnVhH

See column 'C' for SLS Number. type that into the catalogue at sls-hh.de. Click into the product listing page and retrieve the URL into column D as per the sample in cell D2