i didn't read all of your code. but this:
Quote Originally Posted by Kelly mort View Post

Is there a way I can, maybe delete only the CustDb sheet, update it with the new data and leave the other sheets undeleted?
.
does have an answer. select the custDB sheet, delete it and then do whatever you want with your data. your quote really doesn't make sense. it sounds like you want to update something, some sheet. then you wanna del the custDB sheet. and not del all the rest of the sheets. don't know about some of your other talk, but del'ing a sheet is easy:
sheets("sheet name here").delete
don't forget to turn off the alerts before.