I have a long list of names that i need to seperate out into the teams on
different sheets.

On the "team" worksheet in column I, I have the team names and I want each
on a seperate worksheet.

So on worksheet Green I want to get all member, columns A-C and G-H and have
them on the Green worksheet.

I have lots of data and do not want to use copy and past.

THANKS