Buton

beikme Not sure what you are trying to achieve her, but the macros just copy whatever is in cell C2, C3, C4 etc. (presumably from the LIST sheet) into the active cell on the "Outbound A" sheet. So, if that is cell B10, after 40 times,  B10 on "Outbound A" will show the value of C41 from LIST.

If your intention is to copy a range from LIST, like C2:C41 and paste it e.g. in A1 and down on "Outbound A", use something like the following:

Sub CopyAndPaste1()

    Sheets("LIST").Select
    Range("C2:C41").Select
    Selection.Copy
    Sheets("Outbound A").Select
    Range("A1").Select
    ActiveSheet.Paste

End Sub