I have some code that copies the data on one spreadsheet and pastes it into another. The code knows the names of both workbooks and it currently uses the names in the code to activate the workbooks and copy and paste the data.

I want to have only two workbooks open and have the code copy the data from whatever other workbook is open regardless of the workbook name. Any ideas?

The workbook being copied from always has only one spreadsheet in it and the data range is always the same but the workbook name and spreadsheet name are always different.

Thanks