Print array of sheets based on True/False values

I would like to print an array of sheets based on True/False values. I have attached a worksheet to help with the explanation.

On Sheet("Dashboard") H3:H12 are True/False values. I want to print the associated Sheets based on these values. ie: H3=True, print Sheet("Andy"), H4=TRUE, print Sheet("Bob"), H5=FALSE, no print, etc.

I also need to filter the printed Sheets so that if Column A has a value of '0', then filter out that row. For example, Sheet("Andy") has data in A8:A9, but '0' starting in A10:A58, data again shows up again A67, etc.

Your help is appreciated.

Ken

stnkynts,

This works great. Is there a way to have it take you to the excel print tab so you can have print options before printing? For example, select another printer, duplex or single-sided, etc. I guess I'm looking for the icing on the cake.

Thank you in advance,
Ken

Thank you for the other options...based on my testing, I think I will go with your first submission. I appreciate you working with me. Very knowledgeable.