Click Macro button to Paste in corresponding Sheet

[MWhiteDesigns]

Good morning Guys!
Back again. I have another test for you guys.

I have a Workbook, a sheet on this workbook looks up information based on what is inputted in a cell. This information is displayed in a row of cells. There is a macro button I created that when clicked, it will copy all the information in these cells. The code is shown below.

Sub AR_Form_Copy()
'
' AR_Form_Copy Macro
' Macro recorded 7/7/2010 by ayv814
'

'
    Range("A15:R15").Select
    Selection.Copy
    Selection.End(xlUp).Select
    Selection.End(xlUp).Select
    Selection.End(xlUp).Select
End Sub

Is there a way to make the macro button perform as such:

When clicked, it will copy selected cells, then automatically paste it in say worksheet "AR" starting at row 21. If it is clicked again, it will paste in the next available row. Does that make sense?

OR

Same action, slightly different result.

When clicked, it will copy selected cells, then automatically paste it in a completely different workbook in worksheet "AR" starting at row 21. If it is clicked again, it will paste in the next available row. Does that make sense?

As always, thanks in advance!

 

[MWhiteDesigns]

Anyone....?

 

[MWhiteDesigns]

I've poked around the search area for about an hour now. I've tried some stuff here and there but nothing seems to be working. I'm still a baby to excel. Any help would be nice.