NEED macro for complie 3 sheets

[ushaanu]

hi ,
i have one excel sheet one is main sheet where the base data and 3 sheet A,B,C in main sheet whole data unique value in column B in every sheet i need one macro to complie all data of column AA,AB,AD,AE from A,B,.C sheets against B column value in main sheet ,without any changes in main file only put data of column AA,AB,AD,AE of A.B.C sheets
right now i am useing v lookup but every time i use lookup on file after that if value is not able against unique value then for only i put lookup from other sheet .
sample file attached.
thanks
Anu

 

[Deepak]

As i understand you need this on columns AA.

=IFERROR(INDEX(A!AA:AA,MATCH(B2,A!B:B,0)),0)+IFERROR(INDEX(B!AA:AA,MATCH(B2,B!B:B,0)),0)+IFERROR(INDEX('C'!AA:AA,MATCH(B2,'C'!B:B,0)),)