I have 4 worksheets that need to be consolidate into one to form a master
listing, there are known duplicates between worksheets - total ~30000 records
and 30 colums

name hours date project
x 1 10/01/2005 a
x 2 11/01/2005 a
y 1 12/01/2005 b

I then need to compare this master to 4 other worksheets to determine in
which sheet the record is located. Any easy way to do this ?

Tried CONCETENATE and VLOOKUP - keeps crashing :(