I need to sort an worksheet by a cell that is in column D. The tricky part is that I need all the other rows to be grouped with that cell. The number of rows is not constant

The rows that I need grouped together are the users name through Period End. The names will remain constant and the data in column D will remain constant. Hopefully I explain this well enough. Thanks for any help.


A B C D
KIRBY, JUSTIN AHT
Pay Period 1/27/2010 2/2/2010
1/28/2010 7:00 AM 1/28/2010 4:45 PM 9.75
1/29/2010 7:00 AM 1/29/2010 2:00 PM 7
2/1/2010 7:00 AM 2/1/2010 5:00 PM 10
2/2/2010 6:45 AM 2/2/2010 5:30 PM 10.75
Period Hours 37.5
KIRBY, DAVID JHL
Pay Period 1/27/2010 2/2/2010
1/28/2010 5:45 AM 1/28/2010 4:30 PM 10.75
1/29/2010 5:45 AM 2/1/2010 5:45 AM 72.00
2/1/2010 5:45 AM 2/1/2010 10:15 AM 4.50
2/2/2010 7:15 AM 2/2/2010 3:30 PM 8.25
Period Hours 95.50
COFFEY, STEVEN
Pay Period 1/27/2010 2/2/2010
1/28/2010 7:00 AM 1/28/2010 5:30 PM 10.50
1/28/2010 6:15 PM 1/28/2010 8:45 PM 2.50
1/29/2010 5:45 AM 1/29/2010 2:30 PM 8.75
2/1/2010 7:00 AM 2/1/2010 5:45 PM 10.75
2/2/2010 6:45 AM 2/2/2010 5:30 PM 10.75
Period Hours 43.25
STARNES, BRUCE JHL
Pay Period 1/27/2010 2/2/2010
2/1/2010 6:45 AM 2/1/2010 4:30 PM 9.75
2/2/2010 6:00 AM 2/2/2010 7:15 AM 1.25
Period Hours 11.00
WHISNANT, GARY JHL
Pay Period 1/27/2010 2/2/2010
1/28/2010 6:00 AM 1/28/2010 4:30 PM 10.50
1/29/2010 5:45 AM 1/29/2010 1:30 PM 7.75
2/1/2010 6:45 AM 2/1/2010 9:00 AM 2.25
2/2/2010 8:00 AM 2/2/2010 3:45 PM 7.75
Period Hours 28.25