Eng Mat His Sci
Jack 75 65 85 70
Ben 69 75 48 65
Carl 90 82 88 83
Ajay 75 80 80 79


I have data like this in five work sheets (every worksheet contains, one month's data). I want everyone's subject average in sheet 6 (i.e., Jack's English average for the past five months).