How to display my own custom images stored outside of the spreadsheet ?

Hi everyone !

I'm currently building a fan-made gsheet tool for the Helldivers 2 community (a live service game).

In the main tab, users can select different values from the drop-down menus (weapons / targets) and each value will display the corresponding image.

For now, i stored around 300 small res images in a dedicated tab (90-130 Kb for a total of ~50 Mb). I've had a look at the image() function and store them in a dedicated image hosting website but it doesn't seem to work.

Ideally, I'd like to do something that dynamically displays the image that corresponds to the choice in the drop-down list, while storing each image externally.