Create a list while source is just one row

[TheIntern]

Hello again,

today I should create a list while the source is actualized in one row. So the source overwrites the old data with new data, but in the list it should fill the next line. Sorry, I don't really know how to describe it...I hope you Understand^^
It should look like that:
Source:
5 5 5 5
List:
1 1 1 1
2 2 2 2
3 3 3 3
4 4 4 4
5 5 5 5

How can I tell excel not to overwrite the old data and create such a list?

Thanks in advance,

The Intern

 

[TheIntern]

Okay, I kind of solved it like that:

Sub copy()

    Sheets("sheet1").Select
    Range("A4:O4").Select
    Selection.copy
    Sheets("sheet2").Select
    Range("B65536").Select
    Selection.End(xlUp).Select
    ActiveCell.Offset(1, -1).Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
End Sub

now I just need the macro to start everytime the file is updated...any ideas how I can do this?