How to use VLOOKUP Formula that links to Multiple Column with Dates/Value?

Hi Everyone! I hope everything is OK.

I here to ask for your kind help regarding below excel sheet sample

I have a form with a list of Fruits & Vegetables and i want to have the Total Amount of each fruit on the last column by just changing the Date shown above.

On the second excel sheet, there's a table that has the list of all items and the price varies with the date shown above.

So when i change the quantity and date on the first sheet, the total amount will automatically change as per the date.

Please help. Thank you very much!

FIRST SHEET:
LIST.jpg

SECOND SHEET:
Fruits&Veggies.jpg

Hands Down to you, Bernie Deitrick!

Thank you so much! This helped me a lot <3 <3 <3