AutoFill & Calendar

Hello,

I am trying to make an excel document that takes the information inputed in one sheet (Library) and inputs that information into another (Calendar) type sheet according to some conditions.

I would like the information inputed in the Library sheet to appear in certain cells of the Calendar sheet if the day of the week corresponds and if the date of the cell is greater than the start date and less than the end date (information inputted in the Library sheet). I would like to create code for the document to read the date information as a date.

I have made the calendar to have four cell below a cell that states the date. I would like the information in the Library sheet to auto fill into these cells until those cells are filled.

Thank you for your help!

Here is what I've created so far. Thank you

I've attached the sample document.