Okay here's my problem. I have a table with a few columns that are in no
particular order. For example:
Column A Column B Column C Column D
Name 1 Date 3 Reason
Name 2 Date 4 Reason
Name 1 Date 2 Reason
Name 4 Date 2 Reason
Name 2 Date 4 Reason
Name 1 Date 5 Reason

What I want to do is extract the data and create a new list for each name on
a different sheet but with no gaps so for example:

Column A Column B Column C Column D
Name 1 Date 3 Reason
Name 1 Date 2 Reason
Name 1 Date 5 Reason

Any help at all would be most appreciated.