Copy & Paste Macro

Hi all,

I need to collate survey responses that are on separate excel files (approx. 70 excel file) all into one long file. Rather than having to go into each one, and select the range, and copy and paste it etc. I was wondering if it was possible to write a Macro to do that instead. I need it to do the following:

In the "Survey Response" workbook (which will be active when I run the macro), the first range I need to be copied is on Sheet 3 and its is B8:C42.

I then need the values to be pasted in the first available cell in Sheet 1, Column B in the master workbook - called "Master". 

I then need the range in Sheet 4, C8:C42, on the Response Workbook to be copied and pasted in the same workbook, sheet and row as the first copy, but in column D. 

Does that all make sense? I can provide an example if needs be.

Many thanks 

Sam