Try this in A1 of Sheet2, and copy down:

=INDEX(Sheet1!$A$4:$E$4,ROW())
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"jskamm" wrote in message
...
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