The INDIRECT function is a great way to create links between worksheets within a workbook. ... First, we will use the COUNT function to work out how many games the team has played so far.

How does indirect function work in Excel? The INDIRECT function returns the reference specified by a text string. If a1 is TRUE or omitted, ref_text is interpreted as an A1-style reference, ...