I'm trying to set up a macro that will:

1. Open another spreadsheet and copy a set of data...
2. then return to the original spreadsheet (where the macro is recorded)
and paste the data...
3. then close the spreadsheet where the data was copied from.

The issue is, the names of the original spreadsheet and the spreadsheet
containing the data to be copied will always change. How do I set up the
macro to recognize these changes?