G'day Brian

Check out Ron DeBriuns website

http://www.rondebruin.nl/copy5.htm

Copy records with the same value in a column to a new sheet or workbook

There are 5 different example for you to have a look at

1. Create a new sheet for one unique value (AutoFilter)
2. Add data to an existing sheet (AutoFilter)
3. Create a new sheet for all Unique values
4. Create a new workbook for all Unique values
5. Create a new sheet for all Unique values or paste it below the existing
data if the sheet exists

you may find it helpful

HTH
Mark.