Desperately in need of help for absence calendar (queries, relationships and pivots)

Hi everyone, I'm re-working a different version of a calendar that was put together a couple of years back (for various reasons).
I have all sorts of tables prepared (uselessly, I came to now after I saw some tutorials on power query...).
This is the scenario:
- On one side a very simple worksheet where employees fill in dates and choose a type of absence (out of 3)
- A data sheet with tables: organigram, dates, codes for absences etc.

Now, the absences sheet that we want the employees to fill in will have to be shared and filled through Teams (for co-authoring purposes).
This means that it need to stay very simple, and that if the outcome calendar (pivot table) worksheet will contain unsupported features, the absences sheet will have to be separate (but can be in the same workbook as the rest of the data).

The "inspiration" file has many errors in queries and data retrieval, but I will anyway attach it to show what the outcome should be as far as the pivot table goes (I will avoid stuff like buttons, macros etc).
Along of course with my new file.

I understand this is rather complicated and cannot be answered simply, but I'm drowning trying to understand and put in practice queries and connections without any help besides some tutorials on line
So any help will be extremely appreciated.

Thank you for any reply

After a few hours spent watching tutorials, I can now narrow down the problem:
given a name, a start date, an end date and a type of absence, how do I generate a different number for each day of absence in the given time frame on the pivot table for that specific name, so that it will appear in his row?