I have a workbook that creates/updates sheets daily.

I am looking for a macro I can assign to a user control that will print the first page of all sheets whose names falls within a range of data. I need the pages printed/exported into one single PDF file with multiple pages so I can distribute via email.

The range of data is on my Input sheet which I don't want printed. There are also 5 static sheets (Input included) that I don't want printed.

Thanks in advance.