Insert formula as sheet name

[AstToTheRegionalMGR]

Hi,

I am trying to use a formula that can reference text in a different cell and use that text as a sheet name. For example, Cell A2 says Employee1. I also have a sheet called Employee1. In cell B2 I'd like the formula to say "=Employee1!$B$6", then in cell B3, the formula would be "=Employee2$B$6", cell A3 would just contain text "Employee2".

So I'm wondering if I can use a formula to reference cells in column A as sheet names.

I've heard of INDIRECT, but I am unclear how it works

[MarvinP]

Hi Manager's Assistant,

You need this kind of formula:
=INDIRECT(A2 &"!B6") or =INDIRECT(A2 &"!$B$6")
see attached.