Populating a calendar with info from a table

[bcc1579]

All,

I have a table with some specifics for a series of jobs that may either be running concurrently or consecutively.

What I'd like to is to link the data in the table with a calendar in another tab.

The file that I attached has a sample table with a calendar showing how I'd like to be able to see the data. The only pieces that have to come over are the Job ID and the dates. I would really love to be able to see the Job IDs highlighted and color coded. For example, job 4321 would be yellow, 1579 would be another color, 1234 another, etc. But that would all be the gravy on top and is not necessary.

There could be as many as 10 jobs taking place on any given day.

This is sort of a big ask, but I am over my head on this one. A completed book would be marvelous, but I'm open to suggestions and help as well.

Thank you.