I'm trying to aggregate data across several different Google sheets using IMPORTRANGE (or a similar function). The challenge I'm having is I need to reference a dynamic sheet name.
I'm importing an array from one sheet in a different spreadsheet using
But I need to do this for several different SheetName's. I'd like to have a cell (ex: Z3) that contains SheetName and reference that cell with something like
but that syntax doesn't work.
Is there a way to do this?