Connecting a calendar to Excel

[Russk68]

Hi all
I have column A with days of the year. I also have columns with peoples names as the header and each row under the person's name is what they will be doing for that day.
My Question:
Is there a way to link a calendar to each person so they only see their information?

 

[GraH]

Maybe something like:

Mr_Excel_filter.xlsx
	B	C	D	E	F	G	H	I
2	Dates	Pick a Name	Arthur	Domenic	Fluff	Jim	Rijnsent	Roykana
3	15/01/2022		x		out			o
4	16/01/2022		o	w		w	x	o
5	17/01/2022		o	w	w	w		o
6	18/01/2022		o		x	x	w	o
7	19/01/2022		w	w
8	20/01/2022				i		d
9	21/01/2022			w			w	o
10	22/01/2022		x	o		w	w	w
11	23/01/2022			o			o	x
12	24/01/2022				w
13
14
15	Arthur
16	15/01/2022	x
17	16/01/2022	o
18	17/01/2022	o
19	18/01/2022	o
20	19/01/2022	w
21	20/01/2022
22	21/01/2022
23	22/01/2022	x
24	23/01/2022
25	24/01/2022
Sheet3

Cell Formulas
Range	Formula
B3:B12	B3	=SEQUENCE(10,,TODAY(),1)
B16:C25	B16	=FILTER(B3:I12,(B2:I2="Dates")+(B2:I2=B15))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B15	List	=$C$2:$I$2

Or with VBA, linked to the active user. But then somebody else needs to provide it.