Mutiple Printing with a macro, but with a cell selected differently each time from a dropd

[s_twigge]

Hi there,
I'm struggling and looking for help.
I have created a macro, to enable printing, but it's not yet what i wanted, as it does not take into account the change of cell B5...

I have a button on B2 which will enable the macro.
You will see on B5 there is a dropdown list.
I would like the macro to print one copy with each dropdown option selected.
I tried doing this by physically recording it, however after I did it, the record did not save the different selections of B5...

Is there a way around this?

I have attached my sheet so that you can see what the current macro is.

Many many thanks in advance...

[Kamboj]

No attachment