I thought of that, the problem is that there are about 40 sheets. I was
hoping to automate this process to save time. If, like you said, it was only
6 sheets, it would not be such a big deal.

Thanks,

Cindi

"Pete" wrote:

If you sort the data on the Void column, all the X's will be brought
together, so you can easily highlight them and copy to a "Delete"
sheet. You can easily repeat this for each sheet if you only have six
of them, then you have your composite list.

Hope this helps.

Pete