Data pulling from S1 to S2 by matching the dates?

Need Formula help.... and I'm sorry if I explain things awkward but I'll try my best!

So I have 2 sheets

Sheet 1 has The following information (yes the dates are ongoing - just used the screen shot of the beginning

Sheet1.PNG

On sheet 2 I am trying to pull data from S1, but would want it to change as the dates change ( I will be adding a date at the top of Sheet 2 to determine the dates pulled in the chart) and want the dates to be able to determine the information that is pulled from S1 onto S2.

The forecast is empty right now so I want to be able to match the Date in S2 with whats in Sheet 1- and if it finds a date to match, to pull the forecast number from S1 and auto- populate into S2.
Sheet2.PNG

I'm not sure if what I'm typing even makes sense lol so hopefully it does! Any help is truly appreciated.

In the workbook - just trying to match by dates and pull the item from Sheet 1 - C2 cell to Sheet 2 D3 cell.

That is easy enough. However, we can't work with a picture of an Excel sheet.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.