Match Cell date from Column and return value of third column's Cell

I have one worksheet with two tabs. In one tab, there is customer item information: a column with a list of items, a column with the date they want the item and a column to show how many they want on that date ("Order Report" Check Column C for match to cell in "Calendar" K10, then input "Order Report" Description & Min Qty). In the other tab is a rough calendar.
The goal is to show the customer item and qty on the date they want them in the calendar on the second tab ("Calendar" Cell K13 & L13).
I've been trying to input a formula into the cells of the calendar tab that searches the 1st tab for a date, then returns the item and the qty required into the calendar.
I've tried VLookup, but I must be doing something wrong. I found a similar question in an old forum, but was unable to view the solution.
Tab 1.jpgTab 2.jpg

Please upload a workbook with a small, representative sample of your data along with the desired output of the formula/s (manually entered).

This will help us much more than screenshots. Also, we should not have to re-type your data.

Sorry about that - thought I attached the workbook and not the images....

Example Workbook should now be attached along with the formulas I've tried.
Example 1.xlsx
Appreciate any help or direction.

You did not include the desired results in your sample.
I would be weary of using merged cells.

K12 =IFERROR(INDEX('Order Report'!$A$3:$A$34,SMALL(IF('Order Report'!$C$3:$C$34=K$10,ROW('Order Report'!$A$3:$A$34)-(ROW('Order Report'!$A$3)-1)),ROWS($A$1:$A1))),"") Ctrl Shift Enter
Copied down through K17.

L12 =IFERROR(1/(1/SUMIFS('Order Report'!$D:$D,'Order Report'!$A:$A,K12,'Order Report'!$C:$C,K$10)),"")
Copied down through L17.

You can then highlight K12:L17 and copy and paste to all other days. You will have to change the date range to match what row the dates are in.

Attached is this done for 10/13 - 10/21.

Thank you falcondude, the formula change worked for the description, but did not pick it up for the qty:
formula.jpg

You have to confirm the "Item" formula in K12 with Ctrl Shift Enter instead of just Enter.

After doing this correctly, Excel will put {curly brackets} around the formula.

Attached is the workbook from post #3 with the adjusted formulas in place.