How can I use a macro to automaticly select certain rows, add a new sheet and copy these rows to the sheet and then name the sheet according to a cell in that row.

Example
A B C D E F G H
Rec Tag item Time Case# Dispo Descrip Loc
date 111111 1 1300 0000111 D clock G1

I am pulling this information from access. I would like to be able to delete Column "d", select all rows with the dispo code "d" (column F), add a new sheet named "d" and copy and paste these rows to that sheet. There will be many hundreds of rows with 10-12 different dispo codes. I want to be able to do this with each different code. Hopefully all at once if possible. Hope this is clear, if not I will try to explain further.

Thanks for your help.