Referencing jpg to quote sheet

Hi all, long time listener, first time calller.... or something like that.

I'm making a quote workbook for work (just in case you thought excel spreadsheets was just fun in my spare time), and have a dedicated 'Pictures' sheet, which I need to reference on the front 'quote' sheet.

As (maybe) a better explanation, I choose Unit A from a drop down list on my 'Calc' sheet, (I have already made the lookups and other formulae that look up costs etc), and all that transfers to the 'Quote' sheet, along with client name, unit description and other useful information that we need.

Now I want a picture to pop up on the 'Quote' sheet to show clients the same unit.

I have looked all around, but can't find the magic spell/incantation I require to make it work. Any ideas?

Thanks Olaf, I haven't tried the Worksheet_change (I haven't ever used it), and Icurrently do it the manual way - I'm looking for a formula/macro that will directly reference the pic and place it where I need it.