Combine all the data's from different sheet to one sheet.

[cheenu]

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

[Rich Mcc]

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