I have a worksheet that contains drop-down data validation fields that can be updated daily. I want these changes to automatically update & show on another worksheet. Here are the details:
Sheet 1: contains several columns, all are fixed except for a few drop-down data validation columns.
Sheet 2: has the exact same fields as sheet 1, but only contains the rows if specific categories are chosen from the drop-down fields.

I want sheet 2 to automatically update if any changes are made to sheet 1. Any ideas?