TRANSPOSE not exactly what I want

[enash]

How can I achieve the following in Sheet1 from Sheet2 without having to
manually key in the cell references in each cell in Sheet1? Sheet2 has
no column SUMs in row 5. TIA.


========Sheet1========
A B
1 2004 60
2 2005 150
3 2006 240

========Sheet2========
A B C
1 2004 2005 2006
2 10 40 70
3 20 50 80
4 30 60 90


WHERE ...
Sheet1 A1 = Sheet2!A1
Sheet1 A2 = Sheet2!B1
etc.
and

Sheet1 B1 = sum(Sheet2!A2:A4)
Sheet1 B2 = sum(Sheet2!B2:B4)
etc.