I've done very little Excel Programming so I don't know if this is
possible to do. If it is, I would appreciate some reference to a
site, post or book that would help me do it.

1) I want to be able to copy information to one row below the bottom
row of the sheet.
2) I want to be able to automatically extend sum formulas when
information is entered in a cell. This cell "floats" and will always
be one below the last row, on the same same row which the formula is
to be extended to.