Attendance Tracker Consolidation

I have an attendance tracker which has month on month data in various spreadsheets and I have included a spreadsheet named " Summary " , which should basically give me the sum of the leaves for each employee ( pulled from various sheets ) . Please help me .. Thank you