filtering data using seperate lookup table

[hunter_2]

Hi, I am filtering some data based on a yes / no table, but now I have to do multiple worksheets I would like to have a macro to do this, can I hold the lookup table in the code? Here are examples below of before and after. many thanks

product				product
Compressors	1	y		Compressors	1	y
Compressors	2	y		Compressors	2	y
Pressure Vessels	3	y		Pressure Vessels	3	y
Ventilation & Air Con	4	y		Ventilation & Air Con	4	y
Ventilation & Air Con	5	y		Ventilation & Air Con	5	y
Valves	6	n		Pumps	14	y
Valves	7	n		Valves	15	y
Valves	8	n		Valves	16	y
Valves	9	n		Valves	17	y
Valves	10	n		Starters	18	y
Valves	11	n
Valves	12	n
Actuators	13	n
Pumps	14	y
Valves	15	y
Valves	16	y
Valves	17	y
Starters	18	y