Page breaks based on results from Lookup

[Deschutes]

I have a macro that sorts data into 16 worksheets for machine center schedules. The schedules are created from a lookup formula (cell sample)
=IF([OpnOrdrLookup.xlsm]MO1!A37=$A$1,[OpnOrdrLookup.xlsm]MO1!F37,"") to populate the cells. From week to week the different machine centers will vary on lines (rows). My quest is to build a macro that will recognize subtotaled cell data from "(no data)" and set the page breaks and print the woorksheets. I'm having a hard time explaining this delima, but am hopping someone has already invented this wheel.
Thanks