Excel based calendar linked to data table

Good Morning

I've been working on an excel based calendar for work and have hit a brick wall when it comes to linking a data table to the calendar I've created.

I would like to be able to put dates into the data table under the "Data" tab and then have the items that the date corresponds to appear on the calendar in the "Calendar" tab I've made. I've left 5 lines under each date as I probably won’t have more than 5 items happening on one day. I would like for the items on the calendar to be filled in one line after another.

The data on the "Data" tab would be the information on both the X and Y axis. For example, for Building 21 (Y axis) CO (X axis) the date in the table has been set to 07/19. I would like that on the "Calendar" tab under 07/19 the first cell be filled with "Building 21 CO". Additionally, if I had another item such as Building 2 CO on the same date that it would follow in the second cell under 07/19. At first I thought to use the VLOOKUP formula but I realized that it wouldn't work because 1. I'm looking up 2 values and 2. I'm not looking for any one column in particular.

Once I have this set up I wanted to put into place some conditional formatting which for the most part I know how to do. The idea is to highlight certain items based on how many days there are till they happen. I'm thinking the best way to do that would be to create a separate table on another tab that subtracts the number of days between "today" and a date in the calendar that has activities on it. The only problem I would have with that is that I could set it to calculate the number of days between "today" and every day in the calendar but I wouldn’t want that. I’d only want it to do the math for days that have an activity. I'm sure there’s another way but I’m probably just not aware of it.

I hope this post isn’t too confusing and appreciate any and all help. I’ll be checking the forum regularly in case something isn’t clear. The attached sheet is what I'm working with at the moment.

Thanks!