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.