I realize Excel is not the best tool for this but this is where I need to
start. I have a multi-worksheet file. One worksheet has raw data, over 700
rows, 20 columns. The other worksheets have a variety of complex formulas,
conditionals, and arrays. Over time I will be adding more rows. Is the best
way to handle this without changing every formula to name each range and
reset the range when I add rows.

Thanks.