Linking worksheets in different workbooks
 

I have several worksheets that I need to link to multiple workbooks. Each
worksheet in each workbook has a different name. When I copy multiple cells
from the source worksheet and paste to multiple cells in the destination
workbook/worksheet I receive an error message. I assume this is because of
the different cell reference names in the source workbook/worksheets.
Currently, I am copy/paste between worksheets and this is a very long
process. What is the quickest way to get this accomplished?