trying to produce a membership list

I have an excel 2010 sheet with columns for surname, forename, address, district code, and district leader.
e.g.
surname: Smith
forename: James
address: 42 Highdown Road, York
district code: 33
District Leader: Y (if not a district leader the field is blank)

I'm trying to produce a report which starts a new page when there is a change of District Code. I have sorted the sheet in district code, district leader, surname, forename, address
Each page should have the name of the District Leader as part of the heading, and then the forename, surname, address of members.

Something like ...
Membership List by District

District Leader: James Smith

Name Address
David Brodie 16 Wool Gardens, Welling
Jane Marples 78 Christie Walk, Doncaster

I have a little knowledge of excel, but have never used macros or vba.

Any help to get me on the right track will be much appreciated.

RoyUK,
Thanks for your reply.
Unfortunately, the code means very little to me as I don't understand VBA, and what it's trying to do.
Look like this forum is too advanced for me.