Ok, let me sum up the only two questions I think I need at this point.

You let me know if you think I'm missing anything.

1) Why am I getting blanks in the Jurisdiction drop-down but not the Incident drop down?

2) Are there any specific issues I need to worry about when formatting the Pivot Table? i.e. Changing the fonts, colors, etc. Will they carry over as the Pivot Table changes? I will obviously do some testing but thought I would ask as well.

I really can't think of anything else at this point.

I can add investigators and know how to update the Pivot Table to reflect them.

The Pivot Tables do the calculations.

The Log tab can be sorted by any column.

The Data tab can be used to update the drop down lists.

I think you did a great job for me and now I will try to enhance this cosmetically and start adding in the investigators, wiping out the old data, etc.