Collective data from Worksheet 1 to Worksheet 2

[RexcelG]

Data is entered in Worksheet 1 every week. I want a collection of data entered and added to the next row automatically from Worksheet 1 onto Worksheet 2 everytime I enter data on Worksheet 1.

(Week 1)
WS1.....WS2
1/1.......1/1
1...........1
5...........5
9...........9
7...........7
5...........5

(Week 2)
WS1.....WS2..........
1/7.......1/1.......1/7
5...........1...........5
4...........5...........4
6...........9...........6
3...........7...........3
7...........5...........7

(Week 3)
WS1.....WS2......................
1/14.....1/1........1/7.......1/14
8...........1...........5...........8
7...........5...........4...........7
1...........9...........6...........1
9...........7...........3...........9
8...........5...........7...........8

[VBA Noob]

RexcelG,

Please read forum rules below and then add the the link to the cross post

VBA Noob

[RexcelG]

RexcelG,

Please read forum rules below and then add the the link to the cross post

VBA Noob

Thanks VBA Noob. I didn't know.
Here's the Cross-post
http://www.mrexcel.com/forum/showthread.php?t=316998