Ok, what I have is two separate  workbooks. One has two worksheets  in it (I
only need data from one of them), the other has one worksheet. They are both
employee information lists  for my department, but while they have similar
data, they do differ somewhat. One (from the HR dept.) has more columns than
the other and the one with less columns (from the IM dept.) has some that
the other one does not have. The data is updated periodically by people from
both the HR department and the IM department. The merged  document will
reside in our Disaster Recovery folder where only those in the DR team have
access. I think your idea is what I need, so that the summary doc will
always have the most updated info. This info will be used to contact
our employees in the event of a disaster of any kind. I have tried
just consolidating the docs, then sorting based on User ID, which is a
common column in both worksheets, but that does not do anything with the
duplicate entries or the different columns. I need it to get rid of
duplicate ID's but keep the info that is not reflected on the other page.
For example, one has User ID, Name, Phone, Address, Title and the other has
User ID, Last Name, First Name, Home phone, Work phone, Department, Manager,
email. I need it to reflect one user with User ID, Last Name, First Name,
Home Phone, Work Phone, Address, Title, Department, Manager, Email. Does
that make sense?