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.