3 problems-Autosort, Copying, and hard to explain

Alright, I have attached what I have so far (which I'm quite proud of, if that tells you anything.) What I need this xls to do is -
-1. Auto-sort column A alphabetically while keeping the entire row intact. If I use the sort option, the alternating gray and white lines change places and any info in that row will stay where it is while the client name goes somewhere else.

-2. I need to copy this onto multiple xls files, but when I copy, all of the columns resize, conditional formatting goes away, and drop boxes disappear. Is there any way to copy this without losing any formatting? Edit: I figured out that if I have both documents open, it gives me the correct destination, but it still won't copy because the destination is a shared file. Can I get around this?

-3. There will be about 15 different counselors each using a copy of this tab and filling it out. I would like to have each of these tabs saved onto a single, "Master" workbook that keeps each tab separated by name. I have actually already asked about this, but I don't think I'm explaining it very well. I'm sure this will take a macro or VBA, but I have no clue how to use either. What do you think? (Sorry for the noobness.)