If I were doing this I would start from the other end.
I would have a single master list with all the information about all
the members, including which district they belong to.

Then, when I wanted a list for a particular district I would filter the
master list (Data Filter AutoFilter) to see just those people.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup