Combining Data of varying lengths

Afternoon all,

First of all, thanks for reading this. I am not entirely sure I have even managed to describe what I want to do in the subject title properly but, using an example, I will try and explain what I need to do and how I am failing!

THE FIRST PART - Basically, for this example I have three spreadsheets in three separate files/woorkbooks source1.xls
source2.xls and
destination.xls

In source1 & source2 I will have a series of rows of data for example someone's name, address, phone number etc etc with a different person on each line. (Source1 and Source2 are pretty much the same type of file with similar information but are just stored in different locations and edited by different people.)

What I need to do is create a master list of all the combined data in sources1 & 2 and produce it in destination.xls. That seemed simple enough initially but now seems a bit more complicated!

THE SECOND PART of this makes this whole thing more confusing - what I need to do after this is be able to dynamically add new lines into the destination.xls file as and when they are added to each of the source spreadsheets for example, source1 might contain details of 20 people which (hopefully) would be replicated on destination.xls, but as soon as a user adds data to the 21st line it too would be added to the destination and nestle in amongst all the other data...

and the icing on the cake (which technically is a separate project that I could do with filters!) ... would be to only copy over the name once if it is a duplicate!

Please help me with this as I am going mental trying to work out the best way to sort this out!

Thanks in advance...