Perhaps this will help
SHEET 1
DATE | 12/1 | 12/2 | 12/3
tom a | A | C | E
fred b | C | A | F
mary c | A | E | G
bill d | B | C | E

Would like the names retrieved and
dropped into the form {below} based on
assigned letter and by date I input

DUTIES DATE _12/1__

A | B | D | F |

A | B | E | F |

C | B | G | D |

Hope this makes more sense..