Hi again,

thanks in advance..

In Sheet1 (A2 ~ A1000) i have a master list of names.
In 6 other sheets (with varying sheet name) i have a list of concatenated
text containing names along Col. A.

I have a formula to extract just the names on the 6 other sheets (Col A)
Along Col B of other sheets i have a formula, e.g. B2 =LEFT($A2,LEN($A2)-15)

Now i need to compile all the extracted results (from 6 other sheets at Col
B) and
paste them in Col B of Sheet 1.

Then I will perform a sort operation and compare them with data @ Col A..

This is part of a checking procedure i need to perform to compare the
masterlist on sheet1 and the other as listed on 6 other sheets.

Maybe this can be done in excel in the master list of sheet1..
--
regards