Reference Another Sheet In Same Workbook

[Delta Star]

I'm using the formula below which looks at a specific sheet. Rather than type in a specific sheetname I would like to lookup the sheetname from cell H13. I think I need to use indirect but cannot figure out the correct way.

can anyone help?

=MAX(COUNTA(Data!A:A),COUNTA(Data!N:N),COUNTA(Data!AA:AA),COUNTA(Data!AH:AH))+7

 

[njimack]

Data!A:A would be INDIRECT(H13&"!A:A")