If this = this, then perform this action

I have attached a workbook for better reference...

Here is what I am trying to do...

I have 3 worksheets in the workbook. One for First shift employees, one for Second shift employees and a third for Terminated Employees.

Each day when I do attendence, I use a drop down menu to show if the employees are here, called off, ncns, late, termed etc...each work book is for a week of data. So it shows Monday - Sunday. If in one of those fields, I enter the "termed" option, I would like it to automatically populate the employees name, start date, end date (the date it shows "termed"), and the shift worked in the third workseet "Termed".

So, on the third Sheet it would show Jess Donaldson from first shift was termed on Nov 18 and Harold Bigler from second shift was termed on Nov. 19.

Is this even possible? Does someone have any ideas of how I would go about doing this?

If anyone has any thoughts, suggestions, advice, I would really appreciate it.