Help Please ... Visual basic advice required

I wonder if anyone can help.
I am doing some work for a local charity and they have asked me to look at their spreadsheets (Excel), I have managed to do most of what they wanted but now I am stuck.
As I can't get this forum to observe formats I have attached a sample of spreadsheet.

Two workbooks.

A B C D E F

1 1000 1 23-Dec-10 23-Dec-10 y
1 1001 1 23-Dec-10 23-Dec-10 y
2
3
4
5
1 1002 1 23-Dec-10 23-Dec-10 y
2
3

A = MONTH
B = ENQUIRY NUMBER
C = DETAIL LINE
D AND E ARE DATES
F = SURVEY (Y OR N)



2. Survey (worksheet – surveyrecord).


A B C D E F

1 1000 1 23-Dec-10 23-Dec-10 y
1 1001 1 23-Dec-10 23-Dec-10 y
2
3
4
5
1 1002 1 23-Dec-10 23-Dec-10 y
2
3


Example.


What they want is where the enter a record in Enquiry.xls and set survey to Y that record (detail line 1) columns A to N to be automatically be copy/pasted to the Survey.xls ditto other detail lines e.g 1002 lines 1,2,3,4 should automatically be copy/pasted to the Survey.xls in columns A to N. I am not sure if it can be done.
As you can see the enqury number and the survey (y or n) only appear on the detail line1.

HHHHEEEEEELLPPP!!!!