Halp! Excel data exporting

[Warlow]

With workbook("book1").worksheets("sheet1")
.range("B5:B1`3").copy
With workbooks(*"book2").worksheets("sheet1")
,cells(rows.count,"A").end(xlup).offset(1,0).pastespecial
End With
End With

I found this on a random website, would there be a way to modify it to my needs? Would it work at all?

*Note: I tried to fix the indentation but the forum trims leading spaces & tab selects the next element on the webpage. Not too sure how to make it more legible for you guys!