Populate Table Based on Date, multiple matches, for production report

I've attached the file for a production operating report. (Woops, it exceeded the size. I delete all of the tabs that have the production data to make it smaller, hence the REF errors)

What I'd like it to do is this:

As you see when it opens, there is a barrier log to list barriers each shift encountered the previous night. However, I don't want them to type it in there as we will lose the data every day. I have a barrier log tab where I want the barriers entered so I can track them.

So, if the report date is 6/25 (which is just a TODAY()), that means we are running it for our meeting the next morning. The barriers listed should be a lookup from the barrier tab for TODAY()-1.

A vlookup obviously doesn't work because there would be multiple hits for each date. Any ideas? I have an idea this may be another index/match thing, but I've never been too good at that.

Thanks!

see attached added helper column b on sheet barriers and waste issues! this can be hidden or use another column out of sight or even on another sheet!
formula in report B56 nd C56 dragged down i wasnt sure which bits went where just change the last digit to match the column