Use a cross reference website to return results

Hi all, need a bit of help about whether this can even be done. (Im using Excel in Office 2024 LTCS Pro Plus)

Im trying to create a master data table for work, where part numbers for items we sell are displayed alongside their respective equivalents.

I currently have my spreadsheet set like this: https://imgur.com/a/NvI9IZO

Is there a way to have excel scrape the web using sites like this: https://imgur.com/a/5UharO4 and return its answer?

For example, I have a part number BF988. Excel then scrapes the allocated website and returns a result, like P553004.

Any help is greatly appreciated.

Thanks!