All -
I receive a monthly text file I import to Excel.
Column A represents a specific location by code - usually 3 digits with
numerous entries (rows) for each location code. I usually sort by Col A and
cut and paste all the same Col A rows into a new worksheet, thus creating a
new worksheet for each location code. Each worksheet would ideally be named
the location code.

There is potentially 20 or 30 worksheets - which is time consuming to create
manually.
Is there a way to automate this?

TIA
-Jay