I am creating a checklist type data base for construction refurbishing.
We have a list of all items we will do for different rooms, exteriors and so
on.

If I have a 5 page master list and I only want to show the items we will be
performing the work on.

Is there a way to hide rows automatically if a certain cell is blank and
then consolidate the data to a single page or as fits?