Creating Macro That Can Grab Varying Amounts Of Data And Put Them In New Worksheets

I have one worksheet with four columns of data. Column A is a well name, RA-0001, column B is the measured depth of the well from 0 feet to however far down it goes, anywhere from 4000 to 15000 feet, column C is the inclination of the well, column D is the Azimuth.

I have 500 wells from RA-0001 to RA_0500 or so all in this one worksheet, all the wells have varying Measured Depths associated to their well name. I need to create a macro that can separate the wells and either put them in a new worksheet for each well, ie. a worksheet named RA-0001, RA-0002, ..... ect. OR, and this would be nicer, a macro that can actually save all these individual wells as (Formatted Text (Space Delimited)) files with the associated well name.

Here is an example of what it looks like. The columns do not have a subject line to state what information is in each column because I dont need it in that format.

RA-0001
0
0.00
0.00

RA-0001
100
0.91
5.56

[Code] .......

Even just knowing how to create a simple macro that would take all the data from each well so I could manually copy and save them as new files.