Thanks, this is exactly what I was looking for!

I guessed all around it.

The macro (attached to an object) now inserts rows (user specified number) below the active cell (now excluding the header) and then fills in the formulas allowing for a one click update to "grow" the number of rows as needed.

I don't see a way to mark this solved - but it is.