separate large file into separate worksheets (by state)

i have a workbook with over 40,000 records. i need to separate the original into 50 separate workbooks by state. HELP...