Possibly try this
Create named ranges in sheet 'Previous Week Data'
1/. "Filters"
Refers to:=
Use this for Data Validation in "Weekly Performance Overview" A4
2/. "Headers"
Refers to:=
3/. "TASKS"
Refers to:=
4/. "TASK_TABLE"
Refers to:=
Then in Sheet "Weekly Performance Overview" C7
Drag/Fill Down to C16
Repeat this in C20 and C33 adjusting the reference cells in each case.
You have a duplicate "Task" ,Certification Update, I have renamed them ...(1) and (2) to make this work.
You might want to split the Lists "TASKS" & "TASK_TABLE" into the three different categories.
Is that what you need?
Bookmarks