I have an attendance worksheet (A) and need to create an addition spreadsheet
(B) that will reference only the names from the first worksheet.

My issue is that WS A is constantly changing (names added/deleted) and WS B
needs to keep the rows matched up with the correct people (see below):

WS A

Jan 1 Jan 2
Jon Doe Absent
Jack Bauer Absent
Zoe Zoe

WS B

Jon Doe FTO
Jack Bauer FTO
Zoe Zoe

..... SO, Jon Doe was deleted... WS B would look like this:

Jack Bauer FTO
Zoe Zoe FTO

Which is incorrect... any suggestions?