Macro to pull data into multiple spreadsheet

Hihi,

I need some help to create a Macro that will pull data from 1 spreadsheet into multiple spreadsheets (usually 5 s/s).
1) Column A* has 5 different dates (eg: 12 -16 Aug)
2) A Macro will pull out all those with 12 Aug 2011 in Column A roll into a new spreadsheet. It will copy the whole row. A completed example is attached and column C and D** will also populate on the new s/s with cell D1 as the date itself (12Aug)
3) The same process repeats for all other dates (i.e 13 - 16 Aug)
4) Each s/s is saved as a formatted name (it will follow the date - 12 Aug 2011)

*my spreadsheet might not be Col A (pls advise how to change this in my actual s/s)
**my actual spreadsheet might not be in Column C & D (pls let me know how i can change the code in Macro if the column changes)

Thanks loads!