Reference Data When New Sheet Created – Google Sheets
You have a formula that references the same range of every sheet
You want to add additional sheets, and have those sheets added to the formula
How?
There isn't a built-in way to simply "reference every sheet," but with a script, a list of sheet names, and a MAP() function looping through those names, this is totally doable!
Here, the script itself makes a copy of the TEMPLATE sheet, renames it according to a user input, and adds the name to the list.
The formula used here is a double-map function: =MAP(A2:A11,LAMBDA(name,SUM(MAP(E2:E,LAMBDA(sheet,IF(LEN(sheet),SUMIF(INDIRECT(sheet&"!A:A"),name,INDIRECT(sheet&"!B:B")),))))))
Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2
#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
https://www.facebook.com/profile.php?...
https://x.com/SpencersSheets
https://bsky.app/profile/spencersshee...
/ reels
I use Bandicam to record, Clipchamp to edit, and a Blue Yeti microphone
Donate on Paypal: spencer.farris@gmail.com
On this page of the site you can watch the video online Reference Data When New Sheet Created – Google Sheets with a duration of hours minute second in good quality, which was uploaded by the user Spencer Teaches Sheets 21 October 2025, share the link with friends and acquaintances, this video has already been watched 38 times on youtube and it was liked by 2 viewers. Enjoy your viewing!
