title: Copy rows of data from one sheet to another, where the destination sheets are named by dates
body: <p>I have information stored on one sheet of an Excel 2010 workbook, one column of which contains dates. I want a macro which will group this information by date and copy it to other sheets in the same workbook, which I have previously set up and named by those dates.</p>
  
  <p>So I have this information on a sheet called "Source":</p>
  
  <pre><code>Date         First Name  Last Name  Hair Colour
  01/02/2011   Bob         Jones      Brown
  02/05/2011   Geoff       Smith      Red
  03/09/2010   Craig       Hamilton   Blond
  02/05/2011   Chris       Wazowski   Brown
  05/06/2011   Steve       Mac        Blond
  03/09/2010   Tom         Lounds     Brown
  </code></pre>
  
  <p>And I have four other sheets, named: "01 Feb 2011", "02 May 2011", "03 Sep 2010", and "05 June 2011"</p>
  
  <p>I want a macro which will copy the heading, and entire rows from the "Source" sheet which have these dates over to their corresponding sheets.</p>
  
  <p>Data is continually being added to the "Source" sheet, so this is an action I will need to repeat frequently.</p>
  
  <p>I know there is plenty of code on this site which show how to group and copy information over to other sheets by condition, but I haven't found one which works in just this way.</p>