How to set the sheet name in the formula, taken from the text in the cell?

Question

excel

There is a large base with a bunch of sheets. Sheet names are written like S1, S2, .. T1, T2.
One of the sheets is something like a pivot table of these sheets, and there is information from some of these sheets (not from all).
It is necessary to make formulas such as VLOOKUP and GLOOKUP, taking information from these sheets. And I want the name of the sheet to be taken from a specific cell. Those. there is a cell in which the name of the sheet is written (for example, S1) and in order not to write S1 in the VLOOKUP ! , but to take information from the cell.
So is it possible at all?

Answer 1

See INDIRECT.