I am trying to create a Macro linked to an Excel button from the forms
toolbar in cell N1 of Sheet 1. I would like it to perform the following
steps.

1. Copy the entire contents of rows in Sheet 1 from A2 to L30.

2. Sort all the contents of rows A through L based on the acronyms AAAA,
BBBB, CCCC, DDDD, & EEEE and group the AAAA with the AAAA, the BBBB with the
BBBB, and so on. (The acronyms are located in Column F rows F2 through F30).

3. Create and name a new worksheet for all the AAAA, BBBB, CCCC, DDDD, &
EEEE.

4. Paste all the contents of rows A through L containing AAAA in Sheet
AAAA, all the contents of the rows A through L containing BBBB in Sheet BBBB,
all the contents of rows A through L containing CCCC in Sheet CCCC, and so
on.
Do you have any ideas about how I might make that happen?