Is there any reason the data can't all go on a single sheet? I imagine you're collection almost the same data for each membership category and all you'd need is a single column to differentiate the membership category. Extracting summaries, etc. from a single sheet is much easier than trying to do the same across multiple sheets, especially when you start talking about sorting. With a single sheet, filtering by status would be a trivial exercise by comparison to compiling a list from 4 different sheets.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for the reply.

Yes, it could go all on one sheet.. the person maintaining the records is not that fluent with Excel, and I am trying to make it as easy as possible for her, by separating the different types. It also makes it easier for her to print reports, as each is on a separate sheet. We just need a master list now, with only the names. I can probably live without the sequence numbers and the sorting.. just would like a sheet that would update whenever a name is added or removed.

I am going to explore another method of doing this.. thanks!