Question: how to pull data from multiple excel spreadsheets?
Answer: In a new sheet of the workbook which you want to collect data from sheets, click Data > Consolidate.
In the Consolidate dialog, do as these: (1 Select one operation you want to do after combine the data in Function drop down list; ... 
Click OK.