I have the following data from scala:-

Account No. Cost Center Desc. Jan Feb ........ Dec
54000 100 salary 2,500 3000 ........ 4000
54001 100 allowance 3000 4000 .........5000
54002 100 housing 2000 5000.......6000

I would like to extract the data in another worksheet as follows:-

Row# Payroll Related ( heading)
2 Account No. Cost Center Desc. Jan Feb
......... Dec
3 54000 100 salary 2,500 3000
......... 4000
4 54001 100 allowance 3000 4000
..........5000
5 54002 100 housing 2000 5000
.........6000
6 Total 7500
12000 ...... 15000
In this worksheet i have a sum total on row 6, but in next month when i
extract data from scala, what if i have more account no., i would like that
the information is auto extracted with the account no. with the respective
months amount and would automatically add it in rows 6, 7 and then the sum
total is automatically shifted to row 8 without manually inserting additional
rows.

Need your kind help.
thanks
meeru