OK I need to keep data entered from Sheet1 and copy it into Sheet2 but I need
it to put enter it according to date in Sheet1. Data in Sheet1 will always
be in the same place as well as the Date. I would like the copy of the date
to happen either on Calulation function or on save either will do. Workbook
is set to manual Calculation.

Sheet1
A B C
1 Oct - 5 5467 4334

Sheet2
A B C
23 Oct - 1 5443 4231
24 Oct - 2 5423 4098
25 Oct - 3 4567 4123
26 Oct - 4 4987 4143
27 Oct - 5 5467 4334