Excel 2007 : Date comparison and data transfer

[amandeepsharma89]

Hello Seniors,
I am in a novice in excel and have a problem in hand and I am in a real fix. I have 3 sheets in one workbook.
In sheet "summary" I will enter the date manually everyday under the Actual column e.g. 05/24/2012. Now, I want to copy data from "Actual" sheet under the same date 05/24/2012 that I have entered under the "Actual" column in "Summary" sheet. So according to my excel sheet value of Org 1,5,7,8 under date 5/24/2012 should be copied from Actual to Summary.

Similarly, I have to copy the data of the same Org 1,5,7,8 from the forecast worksheet for the next 7 days. I will again enter these 7 dates manually. So, whatever date is there under the 7 forecast column, I need to copy the corresponding values from "Forecast" sheet, Similar flow to the above "Actual to Summary".

So I again have compare each of 7 dates under forecast and copy corresponding data.

I need urgent help, please help me it will be really helpful and will save a lot of time.

Amandeep