Question: how to extract data from one excel sheet to another using formula?
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.