I want a workbook where all employees’ working hours, flexitime,
overtime, leave, etc can be recorded by themselves. Each would have
their own worksheet for viewing, inputting, amending, etc.

Restrictions. We have 4 levels: ‘Workers’, Team Leaders, a Section
Mgr, a Dept Mgr. Workers should have view/amend access to their own
worksheet, Team Leaders: view/amend access to their own + view only
access to all Workers, etc.

I’m thinking of a shared workbook with passwords for each type of
staff member. How would I do something like ‘Add new staff member’
bearing in mind that each staff worksheet has its own formulae in it
and macros associated with it?

Would be grateful for any general ideas.