Using VBA to collect data from work-schedule using multiple criteria

[Thijs_Beard]

Hi Excel Gurus,
For the last few days I'm wrapping my head around an Excel related difficulty and even though I'm pretty used to working with Excel and VBA, I can't figure it out myself.
I have a work schedule as shown below, each number in the schedule represents a different type of work to be done. 1 is Gatekeeper, 2 is Standby, 3 is Vacation etc.
What I would like to achieve is to make a list on another sheet, with all start- and end-dates of the work per employee.
So the output should be like:

Name	Type of shift	Start date	End date
Robert	2	21-02	24-02
Robert	1	25-02	25-02
Erik	2	25-02	03-03

etcetera...

This is the Schedule;

Standby rooster Technisch Regisseur v2.0.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Year		2022							2022							2022
2	Week		8							9							10
3	Day		mo	tu	we	th	fr	sa	su	mo	tu	we	th	fr	sa	su	mo	tu	we	th	fr	sa	su
4	Date		21-02	22-02	23-02	24-02	25-02	26-02	27-02	28-02	01-03	02-03	03-03	04-03	05-03	06-03	07-03	08-03	09-03	10-03	11-03	12-03	13-03
5	Name
6	Robert		2	2	2	2	1			1		1							1		5	5	5
7	Marcel		5	5	5	5					1									1	2	2	2
8	Erik				1		2	2	2	2	2	2	2				1
9	Willy			1			5	5	5	5	5	5	5	1							1
10	Thijs		1							3			3	2	2	2	2	2	2	2	3	3	3
11	Dennis													5	5	5	5	5	5	5
12	Tonny					1							1					1
Sheet2

Who can be my saviour?

Kind regards,

Thijs