How do I automatically generate a worksheet.

[genesis1923]

Hello
I wish to generate a worksheet based on the contents of a csv file. For
example, if the csv file contained the following data:
0,Example Report
1.Group Heading 1
2,500
2,650
1,Group Heading 2
2,890
9,END,0

I would want to generate a worksheet which looks like this

Example Report (Cell A1)
Group Heading 1 Sales (Cell A2 and
the word 'Sales' in cell B2)
500
(Cell B3)
650 1150
(Cell B4 and SUM(B3:B4) in C4)

Group Heading 2 Sales (Cell A6 and
the word 'Sales' in cell B6)
890 890
(Cell B7 and SUM(B7:B7) in C7)

Total Sales 2040 (The
words 'Total Sales' in A9 and SUM(C4:C7) in C9)

The csv file can be loaded into a separate worksheet for data to be
transferred to the main worksheet.

The basic format of the report would always remain the same but the number
of headings and number of entries under each heading is variable. I am
assuming that because of the variable nature of the data I cannot set up a
standard template. I am quite happy to generate the cell definitions, e.g.
B7=Sheet 1!B$6, outside Excel or generate them after the csv file has been
imported. What would be the best approach?

 

[genesis1923]

Sorry about the layout. That's not how it looked when I posted the question.
I don't know how to stop it being reformatted but hopefully from the cell
numbers you can see what it should look like.