This question already has an answer here:
Is there a way i can reference data from another Google Spreadsheet in Google Docs/Drive?
e.g., spreadsheet-A, sheet 1, column A is a dynamic reference of spreadsheet-B, sheet 1, column E
I'm not talking about copying and pasting the data, but referencing its values, in the same way that you could if you were using
=E:E if they were in the same spreadsheet.