To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.