Save Group of Reports as PDF Macro

Closed
Report
-
Hello,

I created a sheet that pulls from other sheets in my workbook to create a report. When one cell value is changed, the entire report on my main sheet changes. I have a drop down box saved with selections for my cell value. I am trying to figure out how to get the report to run through each of my choices and save as PDF for each, preferably in the same document. Is this possible?