Macro to import image based on Cell Value

I have a spreasheet with several workbooks. On Cell B6 of the each of the worksheets I have a reference no. Each reference number has its onw sheet. Depending on the value in cell B6 I would like to create a macro to look for images in C:\Images and return the image matching the reference number.

For Eg if i have "27736" in B6 I would like the macro to look for "27736.jpg" in C:\Images and paste the image in range E3:G10.

Any ideas?

Thank you.