Leave of Absence tracker--modifying data in one sheet due to change in another

Each day at work, I get an email on who will be out on temporary leave of absences. I paste these rows into a large spreadsheet that keeps track of everybody out. The row includes a start date and return date. I added a custom drop-down at the end of the row for whether or not the worker returned to work on their return date; a 'Yes' or 'No' drop-down. I'm planning on having another sheet that filter who has not returned to work yet.

Is it possible to change the value across sheets? Please see my attached example