Question: how to pull data from one excel sheet to another?
Answer: Start typing a formula either in a destination cell or in the formula bar.
When it comes to adding a reference to another worksheet, switch to that sheet and select a cell or a range of cells you want to refer to.