Copy rows into sheet according to entries in Column

[Hblbs]

Hello all,

I was wondering if anyone can help with this. I copy rows of data according the Workgroup entries in Column C and paste them in to the relevant team sheet so that it is separated and printed off. Currently I am doing this manually, as the report length is variable and can be a few hundred rows or sometimes a few thousand which takes up some time. I know I can use the auto filter option, but as I currently use a macro to format this report I was hoping to include it whilst it is being formatted. Also would like to apply all borders to report so its easier to read when printed and a comments column at the end, but this can be done later.

There are teams and 27 workgroups to separate into each team, I have to do this everyday and was hoping to save some time here. I've attached a sample work book as an example.

Thanks in advance.