I have a workbook with three sheets. I want to be able to hide rows on Sheet 2 and 3 based on a dropdown selected from Sheet 1.
Sheet 1 has five columns and 350 rows of unique data that can be sorted. The column headings are Component, WG, Name, Description, Lookup. Lookup is the dropdown and the options are Members or CI. Sheet 2 lists all members for a dept and Sheet 3 lists all the CI's for all WG's in dept. What I want to do is hide all the rows on Sheet 2 and 3 that are not equal to the value in WG field for the row(s) selected based on the dropdown selection.

ex. row 2, dropdown is Members, need to hide sheet 3, unhide sheet 2 and hide all rows on sheet 2 that are not equal to the WG field for row 2 on sheet 1
ex. row 2, dropdown is CI's, need to hide sheet 2, unhide sheet 3 and hide all rows on sheet 3 that are not equal to the WG field for row 2 on sheet 1

Thanks for your help.