Macro help?

Hello --

I am looking to be able to write a macro to do the following:

1. Given a large (thousands of rows) spreadsheet, sorted by values in the first column;
   
2. For each distinct first-column value, combine header rows and the rows with that value;
   
3. Save each spreadsheet with a name delineating the first-column value.
   

I can clarify, if that's not making a lot of sense.

I did some VB programming years ago, haven't done a heck of a lot with VB macros. I do have the concepts, though.

Thanx
Z.

P.S.: I totally wouldn't mind being pointed in the direction of a good web-based tutorial for VBA, either. %-}