How can I copy data from one workbook to my own workbook?

For example:

Workbook1:
File1: // this is the sheet name
File Num Date
1_______2/3/2005
2_______5/3/2005


sheet1:
Workbook2:
File Num Date
1_______2/3/2005
2_______5/3/2005


Thanks.


--
accessman2
------------------------------------------------------------------------
accessman2's Profile: http://www.excelforum.com/member.php...o&userid=27953
View this thread: http://www.excelforum.com/showthread...hreadid=475871