Address function with Sum Sheets function

Hi,
Any help would be appreciated:
I currently have a formula - sum(hull:moshinski!B41). This works well except the cell "B41" needs to get manually changed when I copy the formula across cells that are not contiguous.
I want to be able to place the column number (2 (B) in this case) in a cell at the top of each column, that will house this formula, so that the column number can be referenced in a formula. I would then want to do something like this:
=sum(hull:moshinski)!address((cell reference for column no)),41).
Of course this does not work as excel is not expecting a function after the sum sheets function.
Does anybody know how to formulate this?
Thanks in advance.
Regards,
Nathan68