Here is the deal - In a wookbook, I have a worksheet with 30 colums and 1000
roows, and the number of rows grow each day. I need to build additional
worksheets that will conditionally populate based on criteria.

For example, on the master sheet, there may be a number of rows that all
have an entry, "active", in one column. I want all of those rows to populate
in the second sheet (without blank rows), where I can build a pivot table or
add custom filters.

Ideas?