How can I Split this onto multiple Worksheets using a Macro

Afternoon All,

I have a report Generated from an external source, I Need to copy each customers information into a separate worksheet preferably names as the customer accounts number located in C4, and ever 27th line after. each sheet would then contain all the information for the customer including headings. the problem i have is that the customer list will change as new customers are added onto the list.

Any help you guys could give would be appreciated i'm slowly picking up some VBA, but at the moment I'm just feeling around in the dark so any help or a nudge in the right direction would be appreciated.