Macro copying data from unopened worksheet to open worksheet

Hey guys,

Im trying to find code that allows me to run a macro from the sheet im in and once i run it I want it to ask me which file I want to copy data from I then choose that file, once I do that I want it to choose specific preselected cells and copy that data into specific cells in the worksheet I have open. For example I have copper weight column in t38414.093thickpolyimide file and I want that info copied into the copper weight cells in the glassstocalc file. Now there are several layers and for each layer that gets higher there is more data, but each sheet will have its own Macro. Basically I want to copy data from the t38414 file to the glassstopcalc file. I want the macro to ask me which file I want to open then copy the data from there.