Pulling a picture instead of texts and numbers

Pictures are not really in the cell. For example, if you select the cell just to the left of the picture and then use the right arrow key to go to the cell with the picture, you can type in a formula or value in that cell and the picture will not be affected. Pictures are Shapes in excel and 'float above' the cells in the spreadsheet.
Your goal is not impossible, though. A lot of people use VBA, but I have attached a non-VBA example that should show you the proof of concept, but it is a little tricky. Just type in 1, 2, or 3 into cell C1 and you can see the picture beneath it change.
First, input your pictures and make note of the cell ranges they cover.
Second, create a Named Range using Name Manager. I called mine "MyPic" and used this formula to define it:
=CHOOSE(Sheet1!$C$1,Sheet1!$C$15:$D$17,Sheet1!$C$18:$D$21,Sheet1!$C$22:$D$26)
You can see how the cell C1 is used to choose the ranges of my pictures. Note how the ranges can be different sizes.
Third, select any range of cells and use the camera tool to then place a picture of those cells where you want your picture to be shown.
Finally, click on the picture and in the formula bar change its formula to your named range (=MyPic, in my example).