Hi Mark

IMO your layout is wrong.

I would be more inclined to have 1 sheet to record all the entries in
columns, the mega benefit of this is that you dont have to worry about
complex formulas branching across several sheets.

Date | Emp | Expense | Amount | VAT


You could then look at a matrix grid for your Summary Sheet.

You could also have another sheet which you could use for one-off
employee search | View | Print on a Monthly/Annual basis....

This would mean you will eliminate the need for multiple tabs for each
employee, which would expand & contract due to attrition.

I would be happy to redo your existing and send it to you for your perusal.

Cheers
HTH
Mick.