Wow, that is some amazing work. It also makes sense to me. I like that the user can add items to the drop down lists by managing this on the Data tab. I have done similar things in other spreadsheets but didn't even think about it here for some reason.... probably because I was focused on changing the initial spreadsheet instead of just putting a new one together, although, the drop down fields are not updating when I add items to the list.

So, now I need to tackle trying to add in new investigators to the Pivot Tables.

Other than that, I think this is looking pretty awesome.

Your help has been invaluable.