I created a template to dynamically insert picture by cell, based on cell value, with macro. Pictures are in the same folder as the workbook. The picture is fitted in the cell where it is inserted. When the added picture is clicked, it is displayed in its original size.
Source, sample files : VBA Insert image to cell