I appreciate your insight and suggestions... but as I am still very
much a novice at this, I am not sure how to do some of the items you
note below... When you say to establish the worksheets at the
beginning, I thought that's what I did with the Multipage1_Change()
coding...doesn't this identify the worksheet by name as I activate
the form  tab? If it does, am I having difficulty because, as you
indicate below I don't initialize RowNumber....

I would appreciate any suggestions on this and if you could I would
appreciate your suggestions on what VBA books might assist me...
currently I am using Excel 2003 Programming (Inside/Out). But I find
its' not that helpful...