OK, I have a twofold problem.

First, I scan down the A column for the value "Grand
Total". I need to somehow store the row value for recall
in later code, but am not sure how to do this, or how to
recall it. For instance, I'd like to make my code run
within certain cells in columns E, G, and I and the row
that "Grand Total" is on.

Secondly, I need to total every "=Sum" field above the
specified cell, but can't even begin to fathom how to
accomplish this.

Help is greatly appreciated.