I Employs around 20 people
I add/ delete task during whole day in single work book / having 10 sheets / staff allocation in that sheet

I want to create dashboard where I can view staff wise work allocation

automatic email should go at the day end to all employees for pending work

similarly I billed 100+ clients , from where amount is receivable from them , I want to send automated emails to all clients on click f button