Question: how to create a formula in excel to link data in different sheets?
Answer: Start creating a formula that will include a value from cells in an Excel table.
Click the sheet tab of the worksheet with the Excel table that contains the cells you want to include in the formula.
Select the cell or cells to include in the formula.
Press Enter.