Auto filter column on vlookup update on every sheets of the workbook

[10ml]

I've been seaching everywhere to find a way to auto filter the table (column E8:E) on all my sheets (more than 100) containing a filter that updates when an employee changes quarter (Dw Day week, DWE Day weekend etc.)
It would be nice if it would update automaticly or just when someone opens the worksheets!

Filter test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		678c	Week			Monday to Thursday
2
3	W	Work	Abs	: Absent
4	WA	Works already	6 days	Law 640
5	R	: Refuse	NT	No tests
6	LM	Leave message	NA	No answers	VLOOKUP						Employees external sheet
7							01-oct
8	Nb	Name	No.	Date	Quarter	Status	Date11	Date2	Date3
9		Employee 1	125444	1995-06-27	DW		W				Employee 1	125444	1995-06-27	DW
10		Employee 2	1555725	1999-07-03	DWE						Employee 2	1555725	1999-07-03	DWE
11		Employee 3	145845	1996-07-09	DW		R				Employee 3	145845	1996-07-09	DW
12		Employee 4	545782	1997-06-16	DW		W				Employee 4	545782	1997-06-16	DW
13		Employee 5	421545	1999-05-19	DW		R				Employee 5	421545	1999-05-19	DW
14		Employee 6	158745	1999-08-16	DW		x				Employee 6	158745	1999-08-16	DW
15		Employee 7	235741	2003-12-16	DW						Employee 7	235741	2003-12-16	DW
16		Employee 8	658744	2006-05-23	NW						Employee 8	658744	2006-05-23	NW
17		Employee 9	2555441	2006-06-12	DW						Employee 9	2555441	2006-06-12	DW
18		Employee 10	255444	2007-06-23	DW						Employee 10	255444	2007-06-23	DW
19		Employee 11	254564	2008-11-04	DW						Employee 11	254564	2008-11-04	DW
20		Employee 12	584555	2010-07-03	DW						Employee 12	584555	2010-07-03	DW
21		Employee 13	254521	2011-07-04	DW						Employee 13	254521	2011-07-04	DW
22		Employee 14	587422	2012-05-28	-						Employee 14	587422	2012-05-28	-
23		Employee 15	145687	2013-06-26	DWE						Employee 15	145687	2013-06-26	DWE
24		Employee 16	125487	2015-06-12	NWE						Employee 16	125487	2015-06-12	NWE
25		Employee 17	547841	2015-08-31	-						Employee 17	547841	2015-08-31	-
26		Employee 18	658941	2018-11-07	-						Employee 18	658941	2018-11-07	-
27		Employee 19	212548	2019-05-24	DW						Employee 19	212548	2019-05-24	DW
Test

Cell Formulas
Range	Formula
E9:E27	E9	=VLOOKUP([@Name],$K$9:$N$27,4,FALSE)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K9:N27	Expression	=$F8="C/M"	text	NO
K9:N27	Expression	=$F8="Mal Lt"	text	NO
K9:N27	Expression	=$F8="Equipe"	text	NO
K9:N27	Expression	=#REF!="PT"	text	NO

 

[10ml]