Hello all,

I am trying to get this concept to work but I am having trouble wrapping my head around it.

Basically, I am preparing an excel file for distribution to a lot of others, who have little to no excel experience. Thus, it will have to work well without constant editing, and be fairly dynamic.

I have three types of worksheets in my design: one with setup variables, one with user input fields, and one where totals will appear. The totals type sheet is what is giving me the issue. This is because I cannot predict what the user will name each of the worksheets, and the user may have anywhere between seven and thirty of these worksheets, deleting and adding and renaming at will.

My totals sheet must pull the names of the other sheets (which can be found in a consistent cell across all sheets), then be able to list those names in a column of the totals sheet. I can then indirect the required values along the row(s) using the names of the worksheets.

I am imagining some ingenious use of the IF function, where it seeks out the given cell which holds the name. If the cell is empty by design, then it will skip that entire sheet. If the sheet holds a name in that cell, it will be represented. If that name has occurred before, it will skip to the next valid name in the list. If there are no more unique names, it will return 0, and conditional formatting or Number cell formatting will hide the value. Hoping that it is a fillable function, and is able to compare names to whatever has come before it in a range.

Also, due to a number of reasons, I cannot employ vbscript to do this. God, it would really make my life a lot easier, but there it is.

Any help would be appreciated!