VBA to find date from date range and place a cell value 2 rows down

[benntw]

I have 2 sheets in my workbook for reporting. I am looking for some VBA to match a date on Sheet1 in cell C1 to a date range on Sheet2 (B:8:ABE8). When it find the date that matches it will place the value in row 10 from the cell value on sheet1 cell S6. I don't want it to erase the previous days value. Is there a way to do this ? Need help please.

Thank you.