Google Sheets adds new SHEET and SHEETS functions for multi‑tab pros

With the new SHEET and SHEETS functions, Google Sheets can finally talk about its own structure, opening up cleaner, more resilient formulas for power users. Source