Vlookup value and countif for 5 sheet combain

I have 6 sheet -- sheet 1, 2, 3, 4, 5, are fill with data and to be generated in sheet 6.
Eg:- sheet1:- column a column b column c column d column e
a----------201---------251-------252--------52
c----------611---------231-------362--------42
g----------871---------651-------452--------87
f----------541---------321-------932--------65
d----------012---------325--------772--------31
b----------325---------465--------652--------99
e----------201---------010--------452--------46
same table are in sheet 2, 3, 4 ,5.
I want to calculate in sheet6, is it should look "a" how many time it has occurred in sheet 1 to 5 and then then plus column b from sheet
1 to 5 and then then plus column c from sheet1 to 5 and then then plus column d from sheet1 to 5 and then then plus column e from sheet
1 to 5.
Can i get formula for this if any one please help.

I think you are asking to sum the values of columns A from each worsheet from sheet 1 to sheet 5. The following can be done if the order of the worksheets is not going to change.

Formula:

Please Login or Register  to view this content.

THE GIVEN FORMULA DO NOT WORK.
LET ME EXPLAIN -- IF I TYPE C IN SHEET6 "A"COLUMN THAN ALL DATA OF C SUCH AS COLUMN B OF ALL FIVE SHEET SHOULD BE PLUS AND ANSWER SHOULD BE IN SHEET6 "B"COLUMN ALL DATA OF C SUCH AS COLUMN C OF ALL FIVE SHEET SHOULD BE PLUS AND ANSWER SHOULD BE IN SHEET6 "C"COLUMN ALL DATA OF C SUCH AS COLUMN D OF ALL FIVE SHEET SHOULD BE PLUS AND ANSWER SHOULD BE IN SHEET6 "D"COLUMN ALL DATA OF C SUCH AS COLUMN E OF ALL FIVE SHEET SHOULD BE PLUS AND ANSWER SHOULD BE IN SHEET6 "E"COLUMN
CAN I GET FORMULA FOR THAT

Hi MAHESHP030@GMAIL.COM

You ask

CAN I GET FORMULA FOR THAT

the answer is probably yes, but I have re-read your posting a number of times and I do not understand what you require (others are probably the same). The best thing would be if you posted a small sample of data (say 2 pages of a few lines) and then showed what you expect the result to be.

Regards
Alastair