Combining Data of varying lengths

Thanks for the speedy reply...

I was hoping that there might be a way to do this without macros as I'm not sure a) how in hell to do them and b) if they'll work on the intended computers as they may not be able to enable them... but lets give it a shot anyway!

I have attached a zip with three generic (very unimaginative and made-up) spreadsheets, the two source docs and the destination one. Basically I need the data from the two to appear in the destination one - but the most important thing being that when someone adds to either of the source docs which will be saved onto a different part of a network, the destination will automatically populate with the original and new info.

As I just mentioned, the source sheets (which could number up to ten when deployed in reality) will be located all over a shared network but suffice to say a generic location of x:/projects/OurProject/Myproject would be the sort of structure.

Thanks once again for any help and sorry I forgot to mention that my example sheets are in 2007 format but I'm fairly sure I only have 2003 at work!