Greeting,

I have the following table in 5 sheets (Summary, Jan, Feb, March & Aprial).

Sheet (Jan)
Employee ID Name No. of Absent
1 John 1
2 aaa 2
3 bbb 1

Sheet (Feb)

Employee ID Name No. of Absent
1 John 3
2 aaa 1
3 bbb 4
..
..
..
..
So on.

What I want to do is how to summarize the above table as follows by using
sum if or count if:
Sheet (summary)
Employee ID Name Absent Total
1 John 4
2 aaa 3
3 bbb 5