Macro to Print All Options in a Drop Down List

Hi There,

I have a work book here with several sheets. (The example I uploaded has been trimmed down to show only thing needed). The BICPW links to a two different data sets that I would like to display. This data changes based on the validation list in cell "C"
I need help writing a macro that will go through the list of validations options and then print each page. Basically pushing a ActiveX print button 1 time would print all 10 options pages.

Could someone help me with writing a macro for this?

Thank you!
KJ

Thank you that worked perfect. I see where I was going wrong also. I appreciate the quick response