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.