I don't quite follow - "The sheets within the workbook are given the name of the statement". The Statement Group is F16 Financial Statements, and that's the name of the Excel spreadsheet, so I follow that. The statements included in the Statement Group though are saved as, for example, 'GL!SS-CFDC Operating.DAT', and 'GL!SS-CFDC Inv Fund.DAT'. Should the sheets within the Excel workbook not then be called 'GL!SS-CFDC Operating' etc, rather than 'Sheet-Consolidated Departments(21)'? Where does the wording 'Sheet-Consolidated Departments(#)' come from? I'm sure it's simple but I just can't see it. With respect to a naming strategy, it would be very user friendly to have the individual sheets named as the name of the statement. That's what I understand your reply above to say, though, which is why I'm not following. If that were the case I would save the statements as for example 'CFDC Operating', not 'GL!SS-CFDC Operating', and then I could easily find the sheet for CFDC Operations when I am scrolling through the worksheets in my 22 worksheet workbook.
I appreciate your help, thank you!
Mari