CELL Function in Excel gets you the information regarding worksheet like col, contents, filename, etc Generic formula = CELL ("filename",A1) "filename" gets the full name of the sheet of the reference cell A1 Sheet's cell reference But we need to extract just the sheet name Use Cell Value as Worksheet Name in Excel Formula Sometimes we have different worksheets in same workbook and we need some data for calculation from these sheet in any sheet We can get data from worksheet using reference of cell of specific worksheetTo get the name of the current worksheet (ie current tab) you can use a formula based on the CELL function CELL retrieves the workbook name and sheet, and the MID and FIND functions are used to extract just the sheet name In the example shown, the formula in E5 is = MID(CELL("filename", A1),FIND("",CELL("filename", A1)) 1,255)
How To Use The Sumif Function Across Multiple Sheets Excelchat