vba for when data is changed to remove item from data validation list in another wksh

I'm trying to complete a code so that when data ("no") is entered in Columns "B" "C" "D" "E" "F" "G" "H" in worksheet "Time Schedule" the code will remove a specific data from the data validation list I have in worksheet "Assign Tracking". Basically what will happen is that if an employee doesn't show up for work, I want the sheet "Assign Tracking" to remove that employee's name from the data validation list I have set for sheet "Assign Tracking"
I'm limited in my vba skills and only just started writing this code:

With Target
If .count = 1 Then
If .Row > 1 And .Column = 2 Then
If .Value = "No" Then
Worksheets("Assigning Tracking").Activate

Check your other threads please.