multi-image lookup

Hello,

Tried searching the forum, but I didn't find the exact answer to my question..

I have a large number of SKU's (200+) with their individual images in the next cell, on the sheet #2 of a workbook.
e.g.
cell A1 text "apple", cell B1 "apple.jpg"
cell A2 text "banana", cell B2 "banana.jpg"
... etc

On sheet #1 , I draw a list containing some of those SKU's (one week's sales report in this case).

What I need, is the image to appear next to the SKU on the second sheet once I enter a SKU name in the cell.
Not in the same order necessarily as the source images.

I've only found a way to create a dropdown menu into one cell, which then finds the image for one of the items in the menu.
However in this case I need the image lookup to happen in multiple cells at once, and for the dropdown option I would apparently have to create the whole thing individually for each target cell.

Since I need this for a weekly sales report, copying and pasting the individual images each time takes up a lot of time since I have a lot of SKU's to deal with.
If possible, I am looking for a non macro way to so this (don't really know how to use them..)

thank you in advance!