Chk row for cells with "1" then insert contents of cell to the left into another cell

Hello all. I have a vacation tracker that we use to track what vacation days each employee has scheduled for each day of the month. I need to be able to, in another sheet that is formatted like a calendar, list all employees who are off on each day. My data sheet looks like the following:

sheet1.example.png

The next screen shot is of the calendar and what the results would look like after the script is run.

sheet2.example.png

I did an IF statement that worked... except that there would need to be an IF statement for every employee on each day of the month which didn't seem to be the most efficient. I'm open to any formulas or VBA that would accomplish this.

I would greatly appreciate any guidance.

And another one to play around with.

Jolivanes, thank you so much for this. This helps a lot. Do you think it's possible for the Calendar to be arranged like a standard calendar, with the weeks being on separate rows?

There are a tremendous amount of calendars available for Excel.
Following are just a couple of possibilities found with Google.

https://www.wincalendar.com/Create-a...rom-Excel-Data

https://www.smartsheet.com/ic/easies...calendar-excel

Find one you want and then transfer the data into it.