Copy specific data to a new sheet and save it

Hello,

I am looking for a macro that will copy data based on a specific cell(group name) and paste it to a new workbook. I am also looking for the ability to save the new workbooks with the same filename as the original, with the addition of an underscore and the group name at the end of the filename.

Here is an example of the format of the data

A GroupName C D E F G H ....
x 1 x x x x x x
x 1 x x x x x x
x 2 x x x x x x
x 2 x x x x x x
x 2 x x x x x x
x 3 x x x x x x
x 3 x x x x x x
x 4 x x x x x x
x 4 x x x x x x
x 4 x x x x x x
x 4 x x x x x x
x 5 x x x x x x
x 5 x x x x x x

The original Filename is List_2011-11-10
The original file and filename will be manually created everyday.


I need the new files to only have each specific group (along with the header) and to be saved as so

List_2011-11-10_1
List_2011-11-10_2
List_2011-11-10_3
List_2011-11-10_4
List_2011-11-10_5

I appreciate any help that can be provided to me. If you need any more information, please let me know