I have a workbook with multiple sheets where I would like to read specific (same) cell values from every sheet, and add them to a Summary sheet.
I know this can be done by typing 'sheet name!cell', but I have 100+ sheets, and I read 50-100 cells from each.
The way its done for "Martin" and "John" in the picture is the way I know about.
But can it be done in a way like for "Debbie" and "Leah" ?
Ie., I would like to have the sheet names in column A, and then use the same code for all columns B..Z, ie CELL C5 should show the value from sheet=Leah, CELL=B207.
New sheets are added on a regular basis, and adding sheet name for every column B..Z each time is very time consuming, when you can't just copy the previous line....
Any suggestions?
2021-06-02_170108.png
Bookmarks