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]