Importing Selected Cells from Spreadsheet

I have the need to allow the user to hit a command button and have the spreadsheet automatically copy the contents of selected cells from another spreadsheet into the current spreadsheet. I would like to set up a range of cells that defines the source and destination cells and then use VBA code to open the source spreadsheet, copy the cells, and close the source spreadsheet. Any help would be appreciated. Thanks, Eddie