Attendance Tracker Automation in Excel

Good Morning All,

Im very new to the VBA coding & Macros, I need a favour from You hope i will get help

I have an Excel sheet named as Attendance Tracker in which i maintain attendance of employees.

Now my seniors are asking me to automate the same & their requirements are -

1. we will create seperate sheets for all the team leaders
2. Each team lead should access only their team sheet and should not have access to other sheets
3. We should have consolidated sheet where in all team leads data has to be consolidated.
4. consolidated sheet should be accessible only from managers.
   
   Please help me regarding this.
   
   Thanks & Regards
   Tanveer