Question: how to extract data from multiple excel sheets?
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: ... 
Click OK.