Copy Range of One Worksheet Into Another Workbook

Can anybody help me with a code that will copy a range I give in VB to cells in another completely different excel file? I also would like to incorporate a button into the destination spreadsheet that would basically do this for the user, but because it must be done often, anytime new values are put into the spreadsheet, it would add to the previous values that were already copied over.

This describes how to copy data from and to workbooks:
Input Data From File Into Another Named File

Maybe you can use an event procedure to monitor the file size and then automatically copy cell values.

Events And Event Procedures In VBA

Get the File Size

Thanx for your help!