Calculating total from a different sheet.

In my workbook, I have a sheet for recording Leave taken and the reason. I now want another sheet where I can collect each persons total amount taken.
But rather than simply add each persons amount up and then manually enter it into the new sheet, I would like it to be done using a formula, so it auto updates.