Sorts, page breaks and subtotals, oh my...

Hello to anyone reading this! I'm having difficulty writing a macro and was hoping one of you would be generous enough to help me out.   What I'm trying to do:   I am trying to import data to a t...