How to "assemble" a link with a formula?

Question

Google Sheets

Good afternoon!

Tell me, is it possible to collect in a cell a link to another cell in the table with formulas? When other cells have, say, a separate row with the sheet name (for example, "Data-2020") and a row with cells ("J1") and you need to combine them and refer to the resulting range in the formula ("'Data-2020'!J1 "). And not with a script, but with formulas, so that it is clear to a user who is completely ignorant of scripts.

Answer 1

string concatenation
=A1&"!"&column(A2)