This question already has an answer here:
Is there a way i can reference data from another google spreadsheet in google docs / drive ?
ie. spreadsheet-A, sheet 1, column A is a dynamic reference of spreadsheet-B, sheet 1, column E
Im not talking about coping 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.