Employee Tracker....VBA

Hi Guys,

Can you help me accomplish this project?
The idea of this project is, to automatically track the status of employees.

I have no buttons or userforms yet, but here's the idea
1 button to enter employees on the specific sheets (by the way, the sheet names are team names)

1 button for employees who got terminated


Please see attachment below.

Thank you!

up..........

upppppppppppppp