The INDIRECT function is one of the key functions for referencing data from other sheets in Excel. It allows you to create a reference to a cell or range of cells by constructing a text string that includes a reference to the worksheet name.
The syntax for the INDIRECT function is;
=INDIRECT(ref_text, [a1]).