Some additional considerations.

1. Rename all defined Tables with meaningful names (currently they are default names like Table2, Table3, etc.). (Whenever you rename a defined Table, or column header in it, this change is made automatically in all Table formulas in your workbook.)

2. Define your pick-lists as Tables. Replace your named range formulas for pick-lists with formulas like
The result is, that your pick-lists will be dynamic. Whenever you add a new entry/entries at bottom of Table (no empty row left between Table and new entry), the table is extended automatically, and as result the according named range is extended too. Essential is this for pick-list's Team and Holidays;
No need for pick-lists for data validation lists which have small number of fixed selections (like Yes/No). You can enter such list directly into Data Validation, like "Yes;No" (without equal sign, and without quotes, and I'm not sure about delimiter for your settings).

3. I just did see, that there are several pick-lists with repeated values (Input Target, Authorsing Target, Document Target). Are those linked to task/document type values in pick-lists at left of them? When yes, then make Input Task, Authorising Task and Document Type Tables 2-column ones. Task/Document Type named ranges are not affected, as they are defined for column, and Target's are calculated using VLOOKUP(), like