Automator - textedit/mail to excel

Hi,

Everyday I recieve an email with the closing prices of various Futures Markets in a standardised format. I have worked out how to use Automator to convert this email into a TextEdit file which looks like this--

?

Friday, 26 Jul 2013, 6:59:57 AM

Change

%

Last Trade

High

Low

E-Mini S&P 500, Sep 13

1.75

0.10%

1685.5

1686.5

1671.75

DJ Industrial Average - All Sessions

13.9

0.09%

15556.1

15560.3

15455.5

SFE SPI 200 (S&P ASX 200 Index), Sep 1

-1

-0.02%

4992

4995

4965

...and continues for another 10 different contracts.

What I'd like to be able to do is use a script to copy various excepts from the data set into different sheets of an excel document as the email comes in each day (or manually from the TextEdit file I can already create).

I'd like to format each data set into one row starting with Date from the top of the data set, then Contract name (ie. E-Mini S&P 500), Change (ie 1.75), % (ie. 0.10%), Last Trade (ie. 1685.5), High (ie. 1686.5), Low (ie. 1671.75). A new row would be created for each day's data and added to Sheet 1.

Then, I'd like to do the same with the DJ Industrial Average on Sheet 2 etc, and SFE SPI 200 on Sheet 3 etc.

I'm just delving into Automator for the first time.. and am having a little difficulty working out the best way to do this.

I'd really appreciate any insight you may be able to offer!

Best,
Todd