Vba / macro - job needing done

HI - WE EXPORT STOCK INFORMATION INTO AN EXCEL FILE FROM OUR ERP SYSTEM AND WANT TO HAVE A MACRO OR VBA SCRIPT WRITTEN TO INSERT AND SIZE PRODUCT IMAGES INTO THIS SPREAD SHEET AUTOMATICALLY. THE STYLE CODE ( 6 ALPHA NUMERIC CHARACTERS - IN THIS EXAMPLE GS000920U ) AND COL CODE ( 3 ALPHA NUMERIC CHARACTERS - AGAIN IN THIS EXAMPLE 933 ) ARE IN DIFFERENT COLUMNS OF THE SPREAD SHEET AND THE JPEGS ARE NAMED GS000920U-933-1.jpg .