creating multiple worksheets from one
 

I have a worksheet as follows:
a1: Header: name a2: name of customer a3: Header: VIP a4: info
a5: info a6: info
a7: Header: name a8: name of customer a9: Header: VIP a10: info
a11: info
a12: Header: name a13: name of customer a14: Header: VIP a15: info
a16: info a17: info a18: info
I want to create multiple worksheets to be as follows:
(sheet1) a1: Header: name a2: name of customer a3: Header: VIP a4:
info
a5: info a6: info
(sheet2) a7: Header: name a8: name of customer a9: Header: VIP a10:
info
a11: info in columns a1 ...
(sheet3) a12: Header: name a13: name of customer a14: Header: VIP a15: info
a16: info a17: info a18: info in columns a1...
I can not autofilter because there is different info under the same column
until it finds the next name and the number of rows used is variable, the
header that surrounds the name of the customer is the same for all customers,
can it be possible to create multiple worksheets from this worksheet? Thanks
in advance.