Obtaining a list from a schedule, dictated by date and shift

Hi everyone. This is a great forum.
I'm a new member and I have been teaching myself excel by, developing a production schedule, and consulting this forum, so far I've been going quite well.
I have run into a brick wall in obtaining a list of required production, on a particular day and shift, from an infinite schedule.

I have aattached a similar example to give you all an idea of what I mean. Basically I want to change the date and shift on sheet 2, and have a list of parts and amount required, according to the schedule on sheet 1.( I hope this all makes sense!)

Please help??

Uncle Bear