Ok, one more thing. On your original example wkbk, you have Goal/Task selectable on the GOALS sheet (eg, Goal 1, Task A), and on TASKS you have the same goals/tasks, but with sub-tasks (Goal 1, TaskA1; Goal1, TaskA2, etc.) For a generic solution, you would need a way of linking these sub tasks with their goal/task. I suggest inserting a new column B on TASKS for the sub-task name. So, cells A5 & A6 would have "Goal 1, Task A", B5 would have "A1", B6 would have "A2", etc. Then when you select Goal 1, Task 1, the code would have something to look for in Column A. Would that work for you?