Your Excel data aren't really laid out in a way that's conducive to what you want to achieve, but that could be overcome. It's also not apparent how all this is supposed to work in your Word document. All 5 rows under 'Learning Targets:' have the same dropdown options which, presumably, are meant to result in another set of choices in the adjacent column. So, if Knowledge is chosen for 'Learning Target 1', presumably the adjacent dropdown would be populated with Distinguished, Proficient, Apprentice, & Novice, all from the Knowledge worksheet. But it's by no means apparent what you want to do with the rest of the data on that worksheet.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]