how do i combine excel worksheets

[kgemind]

Working with Excel 2007, we start with a status report of pre-populated
columns and rows of data. Multiple agents independently update the rows that
are assigned to them, while leaving the unassigned rows blank. When all
agents complete the assignment, we must combine their work into the master
worksheet, then delete duplicate rows. What excel function would combine
these multiple worksheets? Any way to easily delete the duplicates?

 

[JR Hester]

Do multiple agents actually add rows of new data or simply have to add
additional rows of original to add their quantites? If not adding truly NEW
row, have you considered using the 3D formula approach. Multiple identiacal
worksheets fro each agents, with a summary sheet to add all agents togenther.

HTH