Well, the doomsday scenario has happened - two colleagues working on the
same spreadsheet fail to communicate. Each has updated a project tracking
sheet at the same time so we now have two new versions. Is there a way of
Excel combining the latest data out of each sheet?

To clarify:

Person X opens spreadsheet version A to update and creates version B
Person Y opens spreadsheet version A to update and creates version C

There is a lot of work entailed in updating the sheets but luckily persons X
and Y have their own projects so they do not update the same information.

Is there a way to combine B and C into a master version D containing all
updated information?

Thanks

Lee