Excel 2007 : Index with Duplicates

dummy updates.xlsx

this is a dummy version of what I'm working on, does this help?

the goal is to be able to change the drop down menu located in raw announcements and have it auto populate into that department's tab without the fields in the A columns of either sheets needing to be distinct.