Thank you everyone for your quick replies. To answer your questions:

Jim: Haha, the function is named. I missed it when i was copying
over and instead of typing out Function
create_working_template_sheet(), i took the lazy man's road and just
wrote function(). It came back to bite me in the end, but hindsight
is always 20/20 :).

Dan: That's an excellent suggestion and one i will more than likely
implement. Thank you. However, i'm still curious as to why the On
Error statement isn't catching the error. This is the first time i've
attempted to use error checking and not very familiar with how it
works. It seemed fairly straightforward, but maybe not?

Don: I'm not sure how that is different from what i've done - except
the order of the process. At the end of the macro, the "Working
Template" will be deleted, and this subroutine is set up to delete the
"Working Template" that could remain if the macro was interrupted for
some reason. It seems as though multiple Template(n) sheets could be
left, so in this situation, i don't think that would work.