Hi

I need to write a macro that will import data contained in another spreadsheet, but am unsure how to do this.

Basically, I have several (about 15) spreadsheets that contain data. I need to import key bits of this data into one central spreadsheet that will be used for reporting purposes. I only need 2 cells worth (values) from each source spreadsheet, to be pasted into the destination spreadsheet, into designated cells.

The source spreadsheets are usually closed down and kept on a file server, which my PC has access to. Ideally I want to activate this macro with a control button - i.e. I press the button once and the macro goes off and collects/updates each field with the latest data stored in each of the source spreadsheets.

All I really need is something that does this for example:

Get data from "C:\FolderName\WorkbookName.xls", "worksheet1" "B21"
Paste it to "ActiveWorkbook", "worksheet3", "D34"

Then move to the next source data file...
etc
etc


I'm pretty sure it can be done, but I'm not very familiar with VB, hence my posting here. Does anyone have any ideas?