Print multiple pages based on cell value to pdf

Your labels are irregularly spaced from the count boxes, which complicates matters. I moved them so they would all be the same.

Also the labels must exactly match the sheet names so I renamed sheet Apple to Apples.

there should be no location set as this will change so a 'Saveas' type option is best.

I have no idea what you mean by this. There is no SaveAs option in VBA for exporting PDF files.