Dynamic Calendar with Autofilling Entries

Hello!

I am trying to create a Dynamic Calendar that will scan dates in a table and return some cells. The struggle is that I think I know how to create the formula but it seems excessive and I wanted to see if there was a better way.

I have the calendar laid out, with date changes based on what month it is set to. I would want the cell below the individual date to check that date and then refer to a table with data and dates. I am looking for it to look for specific brands and the shipping date, and then fill in information based on that.

So ultimately, you just have to set what brand or pack group you are looking at, and it'll tell you when the dates are and what volume there is.

Sadly I can't do any VB with this or I imagine it'd be much easier.

I will attach the Excel sheet and if anyone has any ideas please let me know.

Thank you so much!

The attached (from PeteUK) is model you can use: