Hi
=INDIRECT("'" & A1 & "'!C6)
where A1 stores your sheet name

"Matt Lawson" wrote:

For example, I know I can refer to another worksheet in a cell formula as such:
=Data!C6

However, Is there a way to refer to the name of the sheet based on the name
of the sheet being a variable (ie. the contents of another cell?)

THanks

Matt Lawson