It can be done via formulas, but you would have to provide a staff list, and if the tables were to self generate they would need VBA. It would be easier to sum against the staff list eg calaculate the number of days and occurances sick and the reasons for them. This could all be done with sumproduct functions, then I guess with a few arrays the tables could be populated. with formulas it would take a lot of formulas

I usually avoid pivot tables myself


Regards

Dav