How to preserve data validation in cells while protecting worksheet?

[sandyandy5]

Hi, I'm a rookie excel user that has been getting amazing support from the Mrexcel forum and have encountered another problem. Once I protect the sheet, close it down and open it up again, the data validation to the cells aren't being recognized and only one drop down is available from the dropdown boxes attached to the cell where there is usually 10options to choose from. Is my best option just to leave the sheet unprotected (its a nursing and midwives roster) or is there an easy fix? Below is the layout of the sheet and formuals as well as the data validation formula.
Thanks in advance brains trust, appreciate your time and efforts

Roster Template.xlsx
	A	B	C	D	E	F	G
1	Maternity ward	04 July 2022 -	EFT	M	T	W	T
2		31 July 2022		4	5	6	7
3	Leadership	J PITSON	1.00
4		S COLLIER	0.74
5		D CUSHING	1.00
6		H FITT	0.63
7		J FORBES	0.74
8		H HINSON	0.74
9		S HOCKING	0.21
10		D KERR	1.00
11		K MCCORMICK	0.63
12		S NEWNHAM	0.42
13		B SALATHIEL	0.74
14		T VIERBOOM	1.00
15		M WELCH	0.32
16		M YOUNG	0.63
Roster

Cell Formulas
Range	Formula
B2	B2	=B1+27
D2	D2	=B1
E2:G2	E2	=D2+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D15:AE15	Cell Value	contains ""	text	NO
D15:AE15	Cell Value	contains ""	text	NO
D15:AE15	Cell Value	contains ""	text	NO
D15:AE15	Cell Value	contains ""	text	NO
D15:AE15	Cell Value	contains ""	text	NO
D15:AE15	Cell Value	contains ""	text	NO
D13:AE13	Cell Value	contains ""	text	NO
D13:AE13	Cell Value	contains ""	text	NO
D13:AE13	Cell Value	contains ""	text	NO
D13:AE13	Cell Value	contains ""	text	NO
D13:AE13	Cell Value	contains ""	text	NO
D13:AE13	Cell Value	contains ""	text	NO
D11:AE11	Cell Value	contains ""	text	NO
D11:AE11	Cell Value	contains ""	text	NO
D11:AE11	Cell Value	contains ""	text	NO
D11:AE11	Cell Value	contains ""	text	NO
D11:AE11	Cell Value	contains ""	text	NO
D11:AE11	Cell Value	contains ""	text	NO
D3:W3	Cell Value	contains ""	text	NO
D3:W3	Cell Value	contains ""	text	NO
D3:W3	Cell Value	contains ""	text	NO
D16:AE16	Cell Value	contains ""	text	NO
D16:AE16	Cell Value	contains ""	text	NO
D16:AE16	Cell Value	contains ""	text	NO
D14:AE14	Cell Value	contains ""	text	NO
D14:AE14	Cell Value	contains ""	text	NO
D14:AE14	Cell Value	contains ""	text	NO
D12:AE12	Cell Value	contains ""	text	NO
D12:AE12	Cell Value	contains ""	text	NO
D12:AE12	Cell Value	contains ""	text	NO
D12:AE12,D16:AE16,D4:AE10	Cell Value	contains ""	text	NO
D12:AE12,D16:AE16,D4:AE10	Cell Value	contains ""	text	NO
D12:AE12,D16:AE16,D4:AE10	Cell Value	contains ""	text	NO
AD122:AE126,W122:X126,P122:Q126,I122:J126,I118:J120,P118:Q120,W118:X120,AD118:AE120,D114:AE117,D86:AE88,D90:AD90,D6:AE6,D14:AE14,D26:D28,D20:AE20,D22:AE22,D32:D38,D41:D71,D73:D78,H76:AE78,G77:G82,F76:F78,F73:AE75,F41:AE71,F32:AE38,F26:AE28,E33:E35,E27,E29	Cell Value	contains ""	text	NO
AD122:AE126,W122:X126,P122:Q126,I122:J126,I118:J120,P118:Q120,W118:X120,AD118:AE120,D114:AE117,D86:AE88,D90:AD90,D6:AE6,D14:AE14,D26:D28,D20:AE20,D22:AE22,D32:D38,D41:D71,D73:D78,H76:AE78,G77:G82,F76:F78,F73:AE75,F41:AE71,F32:AE38,F26:AE28,E33:E35,E27,E29	Cell Value	contains ""	text	NO
AD122:AE126,W122:X126,P122:Q126,I122:J126,I118:J120,P118:Q120,W118:X120,AD118:AE120,D114:AE117,D86:AE88,D90:AD90,D6:AE6,D14:AE14,D26:D28,D20:AE20,D22:AE22,D32:D38,D41:D71,D73:D78,H76:AE78,G77:G82,F76:F78,F73:AE75,F41:AE71,F32:AE38,F26:AE28,E33:E35,E27,E29	Cell Value	contains ""	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B1	Any value
D3	List	=OFFSET(Valid!M$24,,,SUM(N(Valid!M$3:M$19<>"")),1)
E3:AE3	List	=Valid!$A$2:$A$17
D4:AE16	List	=OFFSET(Valid!M$3,,,SUM(N(Valid!M$3:M$19<>"")),1)

data validation formula used for this set of nursing staff: =OFFSET(Valid!M$3,,,SUM(N(Valid!M$3:M$19<>"")),1)