could use the & symbol
i.e

combine sheet cell a1
=sheet a&" "&sheetb&" "&sheetc
ect


"cheenu" wrote:

I am having data which is entered by different person's say a,b,c,d & e in
different sheets (a,b,c,d & e). I want to combine all this data into one
sheet called Combine.
Whereas the columns are same in the five person's sheet say (x,y,z). Do you
have any formula for this.

Thanks & regards,

D.V.Sreenivas