create statement from Extract

[griffiths]

I am really struggling with this one. Any help would be appreciated. Some pre works leaves me with a list of people who have travelled. I would like to be able to create seperate workbooks that use the same header as within the data extract. rows 1-6 and then all the data with the same "cost centre owners" (column ad) information within each seperate workbook. So the example

a

b

c

d

e

f

g

h

i

j

k

l

m

n

o

p

q

r

s

t

u

v

w

x

y

z

aa

ab

ac

ad

1

2

3

4

5

6

Client Number

Name

cost centre

Staff ID

Div

ATB

Reason

Class travel

Invoice Date

Invoice number

date of travel

lead name

no of passenger

product name

product code

supplier

routing

Fare

Fare2

Fare3

savings

Savings

Declined

Nett

Vat

Gross

Narrative

Hotel Beds

PNR Date

product type

cost centre owner

7

4673

Company Name

1234

x

25/02/14

1

25/02

a johnson

8

4673

Company Name

1234

x

25/02/14

123

25/02

m smith

9

4673

Company Name

1234

x

26/02/14

114

26/02

k klien

10

4673

Company Name

1234

x

27/02/14

115

27/07

m smith

11

4673

Company Name

1234

x

25/02/14

116

25/02

K Klien <colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody>

12

4673

Company Name

1234

x

25/02/14

117

25/02

M Smith <colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody>

13

4673

Company Name

1234

x

01/02/14

118

01/02

K Klien <colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody>

14

4673

Company Name

1234

x

03/02/14

119

03/02

Richard James <colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody>

15

4673

Company Name

1324

x

03/02/14

120

03/02

K Klien <colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody>

16

4673

Company Name

1234

x

03/02/14

121

03/02

M Smith <colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody>

17

4673

Company Name

1234

x

03/02/14

122

03/02

M Smith <colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody>

18

4673

Company Name

1324

x

7/02/14

123

07/02

K Klien <colgroup><col style="width: 48pt;" width="64"> <tbody> </tbody>

<tbody>
</tbody>

would produce 4 workbooks called "a johnson", "msmith", "K Klien", "Richard James" with 1, 5, 5,1, rows of data respectively. These workbooks would be saved sepeartely in a specified location.