I have a formula in cell G2 of a worksheet called "Departmental Summary"
Column A of the same workbook contains employee names and there is a separate
worksheet in the file for each employee, with the name of the worksheet being
the exact same as the value for the employee in column A.

The formula in G2 is:

=IF(COLUMN(A2)MAX('SheetName'!$T:$T),"",INDEX('Sh eetName'!$R:$R,MATCH(COLUMN(A2),'SheetName'!$T:$T, 0)))

I would like to replace the SheetName with the Indirect function pointing to
cell A2 in the Departmental Summary worksheet, but I can't seem to get it to
work.

Can anyone help me out ?

Thanks !