Build a macro sheet for Excel to pull product imagery & specs

I have an excel template that we enter product SKUs into. We would like to create a macro button that when clicked, looks up the SKUs against a reference list and pulls product imagery from product URLs and embeds the images into the sheet. We also want to pull a few data fields like price and name.

Message me with your proposal and I will send the full detailed requirements with an example template that I've already created.