I'm currently working on several worksheets that require changes to them frequently; I've setup one worksheet with all the data and used Formulas to pull that data in various cells accordingly. All works great!
I've begun to use Conditional Formatting to do various highlights and cell coloring...