macro to split and sort to multi worksheets

[r_aggie]

Hey all, first off...this site is a great resource. I'm so glad I found it!
After doing some searching on the forums, I can't seem to find a solution that I can use.

I have a worksheet that has a about 500 rows of data. I want to be able to run a macro that will run a sort on colmun A. Then copy all the rows that have the same column 'A' value, including row 1 (the title row), into a new worksheet. And then name the worksheet the same as the string 'A' variable. When its done there will be a new tab (worksheet) for every different value in column A. I then want to be able to move all those created worksheets to the same new workbook.

I thought about just recording a macro, and using the Auto filter on column A. But then figured that there has to be some VBA code that would be a lot simpler and also would not be confined by the strict "recorded" macro. If I have a new column A value was added that was not there when I recorded the macro, it wouldn't make it into its own tab. I also couldn't think find a macro that would move all selecte worksheets to a new workbook. This has been killin me for 2 days.

Thanks for any and all help!
It doesn't have to be the entire macro, if you can point me into some directions I might be able to figure it out as well. Thanks again all.
Plea let me know if I was not very clear..I tried.

[stevebriz]

I have wk book where I wrote this...but it too big to post here...
send a send a PM to me and I will give you my email address. then I can send you a copy or if you prefer I can modify mine to suit your data....if you send it to me. It is up to you.
This Wb has has pop up status' s and menu items to make the sheets and delete them