Need to Print and export sheets with data only

Hi Excel Guru's

I have a 5 page invoice workbook produced from a template, I can export as pdf and print the sheets but at the moment it exports the whole 5 pages.
Can I put in a macro that filters the workbook if say there is nothing in B15 on each sheet thay are omitted from the export?
Thanks

I could but the calculations run through all 5 sheets, unless I can run maybe a find value functions on the first sheet, rather than simple calculations.
I will have a play with it and see how it goes, thanks for the idea