Transferring Data From A Excel Workbook to Another Automatically

Hi There,

I'm fairly new at macros and I would like to write a code that will help me transfer data from a workbook to another. I update Workbook 1 every day and I want to be able to automatically transfer my new numbers into my daily report (Workbook 2).

Workbook 1 numbers change everyday and are added to the bottom of a list. I would like to be able to click a button so that the new numbers I get are transferred into workbook 2 automatically.

Does anyone know how I can do this?

Thanks in advance,

Erik