Formulate an auto-updating table for Active Employees. For Google Sheets

[Sribharathi]

Formulate an auto-updating table for Active Employees, including essential details and a summary of the total count of active employees. I need help on this

 

[Fluff]

In future please do what you have been told to do.
As this is for Google sheets I have moved it to the correct location. In future you need to post it in the right section & make it clear what software you are using.