Need a Macro to open every file in a folder and copy data

[monkeyspank]

I am no comfortable with writing macros at all. I have seen sample macros but not really sure if it will do what I want. I have a folder that I will place multiple worksheets and just one range(a2:i2) of information copied from each worksheet to a master workbook. After it is copied I would like the workbook that the information was copied from moved to an archived folder so that new ones and old ones wont be in the same folder. Also, I need the master workbook to recognize that new lines of data are being added to it and update accordingly by adding the new line of data . I have place the master workbook in folder of is own, is this necessary? And, is this possible for all this happen without opening the master file or does it have to be a button? What would the code for the button look like?

Can anyone help?