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!