Pull specific data by date

I need to pick your brains again.
I have a running data sheet. It starts in January and will run to the end of the year and is filled with a ton of data. The data is recorded by date and shift I need to extract data from specific cells and enter them into a second sheet where the data will be graphed monthly.
What I'd like to see happen is pull the date and the data and paste it into the correctfield on the second sheet. (in the attached sample, I set sheet 2 to act as the second sheet.)

I have tinkered with if statements, offset, vlookup, hlookup, etc.
I am pretty confident one if not multiple ones I have listed will work..... I just don't know how..
Any help would be greatly appreciated.

First, check that the dates on both sheets are set properly as dates, then this in C11 of sheet 2:

=IFERROR(INDEX(Sheet1!$B$14:$M$14,1,MATCH(1,(Sheet1!$B$4:$M$4=Sheet2!C$14)*(Sheet1!$B$5:$M$5=LEFT($B11,1)),0)),"")

... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

or can use sumifs as there is need to extract numbers

Formula:

Please Login or Register  to view this content.