Redid a lot of the underlying searches. Instead of going from backlog -> acount -> sales order -> opportunity, I go from backlog -> sales order -> opportunity (which also means I use different lookup files now). I also renamed all the fields to a more human-friendly names, such as 'Sales Theater' instead of Sales_Theater__c. Removed Geo-Areaand added Sub-Theater.