Copy name of worksheet to an error worksheet

Hello all,
I am new to VBA, and I am having trouble figuring this one out. I'm working with a large set of data that is depth dependent. I only put data in where it changes, so I made two subroutines, one that completes a worksheet where I have entered data, and the other that cycles through the worksheets. There are occasional typos with the way the data is written, so I sometimes have problems with the program.

What I would like to do is write the name of the worksheet with a problem to a list on another worksheet, so that I could run the entire cycle, then have a set of pages to go fix. Is there any way to do this? Thanks!

My code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.