How to Reference a cell reference within a formula?

[Perodin]

I am making a label template, and would like to use a single cell to change the references within my bigger formulas.

For example:

=Sheet2!D11&" - "&"$"&Sheet2!M11 is one of my existing formulas

Is there a way to make the "11" parts reference to another cell like N49?
I know it would not work like this, but ill put an example below.

=Sheet2!D=N49&" - "&"$"&Sheet2!M=N49

 

[Perodin]

I am making a label template, and would like to use a single cell to change the references within my bigger formulas.

For example:

=Sheet2!D11&" - "&"$"&Sheet2!M11 is one of my existing formulas

Is there a way to make the "11" parts reference to another cell like N49?
I know it would not work like this, but ill put an example below.

=Sheet2!D=N49&" - "&"$"&Sheet2!M=N49

Figured it out:

=INDIRECT("Sheet2!D"&N49)&" - "&"$"&INDIRECT("Sheet2!M"&N49)