Apple Script for Numbers

Hi

Can someone help me with an Apple Script problem?

My background is Excel on a PC where I have been using Visual Basic. I want to do away with my PC and need to set up the attached spreadsheet in Numbers using Apple Script?

When a name is typed in the column F the row is copied to the next row in the matching worksheet giving me a record of all the transactions for that name. eg Delta row is copied to Delta sheet and Alpha line is copied to Alpha sheet.

I would appreciate any help with the script for this.

Regards