Inserting data from other excel files??

Can you help? I'm lost with this...

I am trying to insert data from various excel files, so that they can be sumarised in a new 'summary' file.

The source files hold costs, total metres of material etc. This needs to be summarised in the file I am trying to create.

Every source file holds the data in the same cell reference, i.e B5 is the cost, D3 is the total m of material etc.

I have started by creating a button, but cant get a macro/ VB code to do this tricky bit, which is insert a file name and path!

Once I have got this sorted the intention is that the summary cells will reference to the filename and path, and input the data required!

I am really struggeling with this. Would be a real bonus if someone can help.

Thanks very much.