Embedded objects query- Help Required!

Hi, 

I'm wondering if anyone can help me. 

I have a list of embedded PDF files within a table but I would like to return a specific embedded file based on a cell value. 

For example I have an embedded PDF for Product 1 in the table which I would like to be pulled through on a summary tab when product 1 is selected from a data validation list.

Is this possible? 

I know it is possible with a vlookup when using hyperlinks to files, however unfortunately I cannot use hyperlinks in this scenario as this file will be going out externally. 

Any help and suggestions would be appreciated. 

thanks in advance

Luke