Using Macros to copy information after a hyperlink selection

Hello!

I am new to recording macros and I don't understand how I can adjust my macro to do a task for me. Here's what I want the little guy to do:

When I click on a cell that contains a hyperlink reference, the macro should follow the reference, select the cell directly beneath the referred cell, and copy that information to another cell in another worksheet.

This is what I have so far, but the selection is too specific (the range is highlighted). How do I just say, "select one cell below the referred cell"?

Also, how can it be copied to the next empty cell, can I specify a particular row and tell it to fill down beginning from the top?

Range("A10").Select
    Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
    Range("A335:H335").Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Sheet1").Select
    Range("C3").Select
    Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
End Sub