Need a formula that queries data by date

Good morning,

I have been struggling with pulling data from 1 sheet by date and am not sure how to write the formula. On the attached sheet, I am attempting to duplicate some formulas that are currently pulling data by which machine the Operator was using, but I need to pull the exact data by date instead. The current formulas are in cells K156 through P165 on tab "Crystal Anderson". I have added an area next to this where I would like to view the new data (B154 through H162). This is a sheet that is used weekly, so I will not have more than 7 days to review, but I need to be able to get the data without manually entering the dates on each tab every week if possible. I am hoping for some type of Query that pulls based off of the dates entered from the sheet. I hope this isn't confusing- please let me know if it is!

Thank you in advance,

Adam