Conditional copying into different worksheets

Hello,


i have excel 2003. what i am trying to do is set up a complaint sheet for 4 different people.
In total there are 5 sheets (Main, Al, Brian, Ken, George)

I want it to pull the name(one of the 4 above) from the G colomn on the Main sheet and copy the information in that row into one of the 4 different work sheets.


All of the worksheets have a header row

this has been bugging me all day :S

Thanks!!