Copying row to other worksheet if cell has specific data

Hi,

I've searched the forums but couldn't find anything that worked for this.

I have an Excel 2003 spreadsheet with multiple sheets - one main one with all data and others which have only the data that falls into certain criteria. I'm wondering if there's a way to enter the information on the main sheet and have it automatically populate the correct "sub-worksheet" depending on what is entered in a specific column.

I'm not describing this well but I've attached a sample of what I mean.....

Hope you can help.
Thanks!