How do I use google sheets get value at address in a formula? or What's the best way to get a value a

Thanks everyone! INDIRECT worked perfectly—didn’t realize it could handle dynamic refs so easily.

Quick follow-up: If I’m pulling from another sheet dynamically (like Sheet2!A1), can I still use INDIRECT?

Tried `=INDIRECT("Sheet2!" & D1)` but got an error. Am I missing something?

P.S. Appreciate the tips on performance too—my sheet’s getting huge lol.