Want to create a multiple page pdf based on excel information

Hi All,

Like many on here my Excel is rudimentary but I appreciate that it can be a very complex tool so I'm trying to find a way to automate something that has to be done at the moment manually.

My company produces quotations based on Excel attached. Each product code has a pdf data sheet for it whilst the highlighted boxes show where the same data sheet applies for various sizes of the same product.

I want to be able to run an Excel/Macro that will inspect the Excel and then produce a Pdf folder containing all the relevant data sheets without duplicating.

It's not too arduous a job at the moment going through the Excel "line by line" but there has to be a quicker way of doing it............which I'm hoping is where the Experts that live and breathe Excel step in, namely you lot!!

Thanks for reading, hope you can help.

Cheers

Paul