Simple macro repetition, I am a total noob

I have a list of stock prices in excel that looks like this

stock prices needed 10/7/2014
UYM 50.85 51.42 49.88 49.93 6410.93
V 210.81 211.09 207.85 208.05 22375.57
VAC 61.52 61.75 60.48 60.58 1001.44
VAL 77.45 77.68 76.73 76.81 4599.69
VALE 11.34 11.58 11.29 11.39 362664.57
VAR 80.69 82.74 80.69 80.82 31238.55


they are the october 7 2014 open hi low and close and volume for the symbols in column a
the list is much longer than I've pasted

I need to copy the data for each stock and paste it into that stocks price file in the row for that particular date. the price file looks like this
10/03/2014 UYM 51.980 52.190 51.460 51.620 139
10/06/2014 UYM 51.820 52.120 51.400 51.600 185
10/07/2014 UYM 0 0 0 0 0
10/08/2014 UYM 49.66 51.04 48.52 51.01 277


i recorded a little macro which will performs the task for UYM. how to I tweak it so it will go down the list of stocks and copy and save the data for each one until I complete the entire list.

here is what I have so far

Sub pleasehelp()
'
' pleasehelp Macro
' Macro recorded 10/9/2014 by okoboji3
'

'
    Range("B2:F2").Select
    Selection.Copy
    Workbooks.Open Filename:="C:\Analysis\uym.xls"
    Range("C501").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("A503").Select
    Application.CutCopyMode = False
    ActiveWorkbook.Save
    ActiveWindow.Close
End Sub

thank you!