Multiple Pictures In A Price List

Hi, I've got a price list with 2500 different lines which the boss has decided need a picture against each one (the guys a legend!!). Can anyone help me with a macro that will look up the code in Column A, then add .jpg on the end, and insert a picture into Column J?? The concept of inserting 2500 different pictures is way to scary !!..

Thanks Heaps