Consolidating Data

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?

How are you determining what items to pick from your master list? Is it a
set of items depending on the job or is it just pick items as needed?

I might be inclined to enter your master list on one sheet and then use
formulas such a VLOOKUP to pick out only the ones that you require from the
master list. Does your master list have a number next to each item or a code
perhaps?

"Steve" wrote:

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?