How to get the right date behind the right name based on today from anoher sheet

Hello people,

I'm new here and I have a question

I'm working on creating a schedule for our team. That works well, but I now want to automatically fill in two cells after each name with the date from another sheet (Availability Service Sheet) in the same document. The second sheet (Availability Service) is filled with names and the availability services. Each service lasts 7 working days, so the names appear more often in column A until the end of the year. Unfortunately, Vlookup does not help because the names appear more often in column A and the schedules appear in column B. I have a sample document that I would like to share with you. Based on today's date, I want to retrieve the correct services from the 2nd sheet after each name. I hope my question is clear, if clarification is needed please let me know.