Macro to copy and paste columns from one workbook to a new workbook

Hi,

I am new to macros and I am not quite understanding them, I need to create a macro that will:
1)Copy the first 5 columns from a workbook starting from Row A5 and down to the last row of data, from first worksheet in the workbook.
2)Paste the copied columns into a Result workbook on first worksheet
3)The pasted data in the Result Workbook needs to be 5 columns to right for each time I use the macro, its continuous data that runs
across. For EX: the first 5 columns will be dumped into Columns A-E, and the next time I extract from another workbook the data is dumped into column F-J and so forth.
4)Create button so that when I press it i can prompt user to enter the name of the workbook to select for extracting data from.

any ideas?

thanks.

because I need to pull the 5 columns from over 20 workbooks and put them going across on the same worksheet in the Result Workbook.
When im done I should have 100 columns going across.

Hello,

Just want to say that i am looking also to do roughly the same thing as Windcloud2 except I would copy only 1 column but that should be easiliy modified in the macro. I personnaly would like to have the data just dump into the result worksheet without prompting the user to select the workbook to pull data from as I would be looking more at 100-200 workbooks so if someone could provide an answer/macro to that as well that would be great. Thanks!