Another way is to have workbook sheet events that can manage all of your sheets. You would need some sort of naming convention in your sheets so that it would also handle new sheets, but it would be much simpler and more manageable.