Excel Macro code require please hep me

[akumarchary]

Dear Experts,

Sheet1, Column1, Column2, Column3, Column4 Values keep changes live data every 10mins in same one Row2 of 4 columns like below
Column1, Column2, Column3, Column4
Row2 = 1, Row2 =,1 Row2 = 1, Row2 = 1 (10 mins)
Row2 = 2, Row2 =,2 Row2 = 2, Row2 = 2 (20 mins)
Row2 = 3, Row2 =,3 Row2 = 3, Row2 = 3 (30 mins)
.
.
So, I need to capture all data occurred of 1 hour into another sheet2 like
Column1, Column2, Column3, Column4
1 1 1 1
2 2 2 2
3 3 3 3
4 4 4 4
.
.
.
.

Kindly help me. I would like to know what and all data coming in very 10mins for analysis purpose.

Thanks a lot in advance and really appreciate if someone help me in this matter.