One way is via index/match

I'll assume that Sheet2 and Sheet3's col C houses the key IDs* -- uniques
which could be used for the matching, and that cols D & E contain the info
that you wish to bring over to the main Sheet1

*IDs are the text numbers in col C in Sheet1 that you posted, viz.:
012345
014652
(it's better to match based on unique numbers rather than using names)

In your main Sheet1,
In E2:
=IF(ISNA(MATCH($C2,Sheet2!$C:$C,0)),"",INDEX(Sheet 2!D:D,MATCH($C2,Sheet2!$C:$C,0)))
Copy E2 to F2. This'll bring in cols D & E from Sheet2.

In G2:
=IF(ISNA(MATCH($C2,Sheet3!$C:$C,0)),"",INDEX(Sheet 3!D:D,MATCH($C2,Sheet3!$C:$C,0)))
Copy G2 to H2. This'll bring in cols D & E from Sheet3.
Then just select E2:H2, copy down as far as required.
Unmatched cases, if any, will return blanks: ""
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Morgan DeMarco" wrote:
I have data in 4 different spreadsheets. My main sheet has data organized as
lastname, firstname and then relevant data accross the row.
for example:

smith, john, 012345, 78914
smith, randy, 014652, 87263

I'd like to combine the data on the other sheets for each person, so that
sheet #2's data for john smith is added after the 78914 cell, and then sheet
#3's data and so on, while removing data from sheet's 2, 3 and 4 that doesn't
correspond to the names in the main sheet... is this possible? And is there
an easy way to do this other than copying and pasting everything into one
sheet and then going line by line and deleting rows that don't match up?...

Any help would be very much appreciated.