@Pocohantas In a small organisation, I would create a worksheet per employee as indicated in my post above. With the first work sheet being a summary as the per original worksheet indicated above. This enable you to look at an individual leave or you can look at the entire company.

If you are a bigger organisation, buy a software solution.