Copy Rows to another Worksheet Based on a Condition

[patxlb]

I have created a worksheet which contains seven columns of data and many rows. I need to copy entire rows into nine separate worksheets depending on the data in column G.

I know nothing about VBA but have read enough to realize this is the way to go with this. Would someone point me in the right direction on how to set this up?

I've attached the file so you can better see what I'm talking about.

Thanks. Pat