Exporting data from one excel spreadsheet to another excel spreadsheet

Hi All,
I have a excel workbook containing 20,000 rows of data. I will have to develop a macro to copy a certain range of data from that excel workbook & paste the same in another excel workbook, rename the workbook & save. Suppose one column contains certain rows with values as 1, next set of rows as column value=2, another set of rows as values =3. I will have to take all the rows corresponding to value 1 and paste in the second excel workbook, rename, save & close. This process repeats for column values=2 & 3 as well.Please help in writing the Macro Code.

The source Excel resides in the location:E:\Ani\SIMS
The destination excel resides in the location :C:\AM\SIT

Please help me in writing the Macro for the same as this is URGENT for me. Looking forward to your kind assistance with the Macro Code for the same.

Thanks
Ani

It depends upon how many values like 1,2,3 etc are there upto 10 ,20 or 100

now I shall tell you how to go about

autofilter for 1 in that column
copy filtered data to the destination workbook and save as in another name and close
come back to original file and remove autofilter and again autofilter for 2 and do same action.

you can RECORD or write a macro for this;. if the values 1,2,3 etc are large you can loop it through for each step of 1

can you work on this?