List multiple sheet names RRS feed

  • Question

  • Hi all,

    I am not working with excel very often, but I need to accomplish a list of worksheets.

    I have a workbook with 24 sheets. Each sheet is named according to an item name.

    I need to create a summary sheet where each sheet name is displayed together with the closing balance of each item.

    To display the closing balance on the summary sheet, in column F, I use the following formula:

    ='8F70140800 - Sharpners 25mm'!A29

    In Column B I need to display the name of the sheet, but I cannot do it with a formula. The summary sheet should look like this:

    Is it possible to display the sheet names on a single sheet without having to type in each sheet name?



    Tuesday, April 30, 2019 1:31 PM


All replies