That's kind of what I was afraid of.

The idea of this workbook is to serve as a quick way to populate tracking data and autograph it into linked word documents. Thus, each graph on each worksheet will be linked into a word document. By using a single set of graphs, it would require the user to switch back and forth between a linked word document and the workbook, updating one at a time. Even though that would be a simple task for most people, if I have an in intern or assistant trying to populate the linked word document, it introduces a more room for error.

I'm actually kind of okay creating the graphs by hand if that's what needs to happen. I can create a copy of the workbook and reuse it for separate caseloads. Though it would be a task, putting in a bunch of work in on the front end would be worth it.

Would it be simple enough to create the dynamic range names via macro?