I've added the links and edited the VBA code. My next question...

With the linked cells, when I change the data from the source workbook,
it automatically updates in the destination workbook. Why would I need
to use the Macro to copy and paste, besides opening up the destination
workbook?

As well, how do I get the linked data to automatically be pasted into
the last line of my desination worksheet every time new data is
transferred to the destination workbook?

Thanks for all your great help:)


--
tanyhart
------------------------------------------------------------------------
tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148
View this thread: http://www.excelforum.com/showthread...hreadid=551008