Extract variable data from the web to specific cells

Hello everybody,

is it possible to extract data from a specific website and enter this data then to defined cells?
I would like to enter a product number in excel and then search for this product number online and it should enter the price and the name of the product in excel.
The idea is to make a search engine with excel but enter the extracted data only to specific cells

I cannot send the real website, because there is access needed, but I have tried to make a samplebook with kaiserkraft. ch.
With the real website there is a login necessary, so the website will be opened in chrome already.

Thank you in advance for your help and best regards,

David

Does anyone have an idea?
I've tried to do this with Power Automate and copy the text from the HTML-code but that doesn't seem to work properly...
Every help is greatly appreciated!

Thank you, David