how to get data into different workbooks

Hello,
In the attached excel file, groups follow a pattern, with a new group for every 6 elements.
I need to create different samples of these groups into different workbooks. Example pick the first 2 elements of each group into one work book. ( so there will be Amy,Alan,Bea, Brenda,Carrie,Carol) in this. Pick the next 2 elements of each group into another workbook(Aron,Allen,Brad,Brick,Chad,Charles)etc etc.
Is this possible?
Alternatively instead of putting them in separate work books just total the amounts in the first 2 elements of each group , then total the amounts in the next 2 elements in each group and so on.
The actual file has many many more groups with 256 elements in each group.
Any help appreciated.
Thanks