Print specific pages based on a specific cell on each page

Hi all,

This maybe my first post but have used the website for ages, now I'm stuck and in need of help

I have 16 pages in sheet1 and 30 pages in sheet2. On every page in both sheets there will be a specific cell, if it has a "Y" in the cell when I print only those pages are printed and not the cells with "N" , so I could have 10 pages in sheet1 and 13 in sheet2 that all contain "Y" in a specific cell that when I print only these pages print off.
The cells will either contain "Y" or "N" which will be updated from another workbook.

Thanks
Dan