What would I need to do to get a picture to automatically insert into a cell?

In a separate cell, the filename will appear (such as HP97).

I want something like


=INDIRECT.EXT("'G:\shared\data\["&L22&".jpg]")

where cell L22 would provide the detail such as HP97

The remote directory will have hundreds of jpg files, so I cannot consider
the McGimpsey solution which requires the photos to be hidden in the excel
document.

Following the insert of the picture. I would prefer that the picture is
scaled to fit, but if this is not possible, I can scale the original pictures
myself before saving them into the directory.