Here's my problem.

In worksheet 1, I have summation formulas in a one row, at a4, b4, c4, d4
and e4.
I want to put the results of the above sum formulas into a different
worksheet and put them in one column, such as a1, a2, a3, a4 and a5.

Can anyone help me?'

Thanks