Macro help needed
 

I have setup a macro to open another workbook and extract information. The
macro inserts a new line before extracting the information. I keep this sheet
as a raw data sheet. i.e.
Sample Date Result
A 11/30/06 12
B 11/30/06 3

What I am trying to do is to take the newest row of information and copy it
into another sheet, the info for Sample A is copied into a sheet named Sample
A and the same for Sample B.
How can I do this? Is it possible to do this without needing the raw data
sheet?