IF (cell text value) THEN copy & paste from another workbook

[AndrevdS]

Hi All,
Virgin poster here, rookie VBA user...please be gentle...

I have a Master workbook which automatically compiles various worksheets drawn from different Project workbooks (no code involved, just links)
Besides the linked data, I also need to copy/paste tables and graphs depending on cell values.
So to cut a long story sideways, I need to do something like the following:

CASE (cell-value in Master workbook) COPY (RANGE from Project workbook) and PASTE as a linked picture.

Is there any civilised way of doing this?

Thanks,
A.

 

[AndrevdS]

Any ideas?