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

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

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

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