Excel to Excel data

[wonsonboy]

Hi

I have to get some data from a series of Excel Files and copy it to specific cells in another master Excel document.

So the code I need will have to select/path to a series of Excel files, open them, get the information I need and then paste to another workbook before closing.The format of the Excel workbooks are identical...only the data varies.

Any help would be great and yes Im a newbie.