Append data to a separate workbook
 

I have built a survey that will be sent to multiple users. The users will
complete the survey and then click a submit button. What I need to happen
once that submit button is clicked, is for the results to append to a summary
file.

Below is an example of the structure and data.

Survey.xls
Results Worksheet
A B
1 Q1 4
2 Q2 5
3 Q3 2

Survey Results.xls (location: F:\Results)

I need the data in range B1:B3 of the "Results" worksheet to automatically
append to the next available column of the "Survey Results" workbook.

Thanks,