Have you considered using Data/Consolidation? With this you can consolidate data from multiple spreadsheets into a single spreadsheet.