|each time the form is "accepted"|
What do you mean?
To copy data from one sheet to another simply specify the other sheet. IE
On sheet 1 cell a1 you have todays date
On sheet 2 cell b1 simply put the formula sheet1!a1 and cell b1 now has the same info as sheet 1 cell a1.
Also if you post Excel questions in the Office Software forum you might get a larger response.