Excel Excel 2003 Macro

[PaintMixerB]

Hello, I am new to excel and I was hoping someone would be kind enough to offer some help. I have made a spreadsheet for entering data daily, and I would like to make a macro that will copy the data from cells (Sheet1 D6 to D20) to another sheet in the same workbook(Sheet2 B2-B16, then C2-C16, D2-D16 and so on). I would like it to add the data to the column with the corresponding date, so the macro would be conditional on today's date. Meaning, after I enter today's data, and click the "submit" macro, I would like the info copied to a spreadsheet on the third sheet into the column with today's date.

Any help would be greatly appreciated. Please let me know if you need more info, like I said, I'm very new at this.

Thanks for your help!!