Question: how to pull data from one workbook to another in excel?
Answer: Open up the second workbook by selecting File > Open and navigating to the file or by selecting File > New.
Select the cell from either workbook or worksheet where the formula should be entered. ... 
Select the cell to be added to the formula by left-clicking the cell.
Repeat step 3 as many times as needed.