Append Cell Content to a New Line in another Workbook

[AndrewTrevayne]

Hi everyone,
I was hoping if anyone could help me.
I am trying to figure out a vba that can append data input from one of my Excel Workbook into a new line of another Workbook.
Basically I have 2 Excel documents, the 1st one is where I key-in the data. The 2nd one is where I want these data to be recorded.
I tried recording a Macro however instead of adding a new line for each new record, it just overwrites the previous entry on the target workbook.

I have attached the 2 Excel Files, I am storing these 2 documents on "C:\Temp" location on my hard drive.
My files are:
Source = C:\Temp\Input.xls
Target = C:\Temp\Target.xls


On the Input.xls

Heading	Heading
Name	Bruce Wayne
Address	Gotham city
Telephone	666666666
SUBMIT BUTTON

<tbody>
</tbody>

On the Target.xls

Name	Address	Telephone
Clark Kent	Smallville	999999999
Oliver Queen	Starcity	888888888

<tbody>
</tbody>

On this example, I'd like to insert the entry on the Input.xls to the last record of Target.xls
Can this be done? Would really appreciate any help. Thanks in advance.​