Need help to auto calculate annual leave/sick leave day

Andy,
simply create a table in each tab with the formula that will calculate the balance after each month and that will carry over to the next tab. See attached example for months Jan - Apr to give you an idea.

Alternatively, you can put everything on one sheet (easier, in my opinion) and simply calculate the balance. See "Alternative" tab. Hope this helps.