Good day,
I'm trying to consolidate information across multiple sheets into one sheet. I've been trying a few different things but cannot seem to be able to figure this one out.
I need to have a list of all the values that appear in "T11" across multiple sheets. All my sheets are named Sheet1, Sheet2, Sheet3, etc.
I was trying some things like {="Sheet" & Row() & "!T11"}. However, this doesn't quite work, it just displays it as Sheet3!T11 in the cell and doesn't give back a value from sheet 3, cell T11.
I've tried Index, as I need this done in mass across all sheets from SheetX to SheetY, where x and y are the minimum and maximum value of sheets I need. However, this just returns errors.
Any assistance would be appreciated.
I'm trying to consolidate information across multiple sheets into one sheet. I've been trying a few different things but cannot seem to be able to figure this one out.
I need to have a list of all the values that appear in "T11" across multiple sheets. All my sheets are named Sheet1, Sheet2, Sheet3, etc.
I was trying some things like {="Sheet" & Row() & "!T11"}. However, this doesn't quite work, it just displays it as Sheet3!T11 in the cell and doesn't give back a value from sheet 3, cell T11.
I've tried Index, as I need this done in mass across all sheets from SheetX to SheetY, where x and y are the minimum and maximum value of sheets I need. However, this just returns errors.
Any assistance would be appreciated.