Excel VBA Macro to be done within a day

Create an excel VBA macro to input a picture into a specific cell depending on the content of another cell on the same row. The macro will need to loop for a range. There are 7 pictures and 7 corresponding words in the cells (the pictures will have the same names as the corresponding words).

I'm guessing it will work with if cell contains this word then display this picture, elseif it contains this word then display this picture for 7 possible pictures. The macro doesn't need to resize images although it will need to specify where in the cell the picture will be located. To begin with this will be at the top left of the cell but may need to be slightly lower or further across.

I'm under a confidentiality agreement for a much bigger project which this is part of so the attached is an example workbook to apply the macro to and then I will copy the code over to the confidential workbook. The cells with the words in are located on sheet1 column E (highlighted yellow for the example file) and the picture locations are in column A (highlighted green on the attached example file).

I will potentially need this to work on more than one sheet of the workbook as well.