Storing Information By Date

Hello,
I've created a workbook that I use daily. The workbook has two sheets. One for entering information. The other for storing information.

On the first sheet, I enter health information about myself. I also enter the date.

On the second sheet, I have rows dated from January 1, 2009 to December 31, 2009. If the date entered on the first sheet matches January 1, 2009, then the information is copied to that respective row. If the date entered on the first sheet matches January 2, 2009, then the information is copied to the corresponding January 2, 2009 row, etc, etc.

So far so good. I enter the information, the date, and instantly the information is copied over. I save the workbook and go to sleep happy.

The next day I enter in my new information (replacing yesterday's information) and enter in the new date (replacing yesterday's date). As soon as I enter this new date, the new information is instantly copied to the new corresponding row on sheet 2. Perfect, right? ---- But not exactly... the information I stored the previous day disappears!

I want to store information everyday for the next year. Right now I'm only storing the current day's information and nothing else! When the date on sheet 1 changes, my "IF-THEN" formula for the day before no longer holds true and those values are lost.

I've read about making a form using VBA script. But I can't use VBA, because I'm on the mac version 2008. I also can't use apple script because I'm sharing this workbook with a windows user.

Is there anyway to make a form without script? Is there anyway to accomplish my goal without using a form?

Thanks for your help in advance!! I am desperate for a solution!