Automate PDF export based on selected criteria

[Jono_NZ]

Hi,

I''ll do my best to explain what I'm trying to achieve:
1) Select chart data based on changing Name from List. This repopulates chart data
2) Select chart output page
3) Copy sheet
4)Select next Name from list... repeat

At the end I should have twenty tabs which I can then export as a PDF and send out.

Thanks!

 

[Jono_NZ]

Anyone have any ideas here?

I realise I probably need to export each page as a separate pdf BUT if there is a way to compile them into one doc that would be a better option.

Thanks