I have make a survey once a week with certain activities for different employees.

Date Monday Dec 03 2012
Total Subtot X Subtot X % Subtot Y Subtot Y %
A1 B1 C1 D1 E1
....
....
....

Total Subtot X Subtot X %
(A1:A50) (B1:B50) AVG(C1:C50)
A56 B56 C56

The row A56, B56, C56, D56, E56 is supposed to go to another sheet, which I can do manually
to a history chart.

SHEET 2

Date

November 12 Total Subtot X Subtot % Subtot Y Subtot %
November 15 Total Subtot X Subtot % Subtot Y Subtot %
November 17 Total Subtot X Subtot % Subtot Y Subtot %
November 21 Total Subtot X Subtot % Subtot Y Subtot %
Here I want to add automatically the row 56 (sheet 1) from my survey each time.
When I do my next survey it s going to be the next row below.

Is it MACRO time or... Any inputs from the excelforum society that has helped me so much?