Copy data on daily basis dynamically

[Regash]

I have an excel sheet that contains all of my data named (Book1), and that excel sheet (Book1) updates on daily basis. What I want is to transfer the data for each date to another excel work book (Book2) on daily basis, without over writing the old data on the work book (Book2). For example if date=Today in book1 then transfer the data to Book2.

 

[sijpie]

Where in book2 should the next day's data go? below the previous, all on the same sheet? Each day on a separate sheet?