I have a file with tracking information. One worksheet has the names of all
the people I am tracking, each with their own worksheet. I also have a
UserForm that is used to add people. I would like the following 2 things to
happen (more than likely in my cmdOK_Click event):
1 - Copy a worksheet from one of my existing people, blank out the info, and
rename it the value in my Name field in my UserForm (I used to know how to do
this, but it was last year when I last had the code);
2 - Sort the placement of the worksheets with the people I'm tracking so it
is in the same order as my master worksheet with all the people listed. (I do
not want all the worksheets reordered; just the ones for the people I'm
tracking.)

Any help on this is greatly appreciated, as others will be using this file.
TIA.
--
I am running on Office 2003, unless otherwise stated.