Select Multiple Sheets for NAME MANAGER

[superclass12]

In Excel 2007, I go to Formulas--> Name Manager and create a new name for multiple sheets. Let's say I have Sheet1, Sheet2, and Sheet 3.
In the refers to section, I type ={"SHEET1","SHEET2","SHEET3"}.
However, what would be an easy way to define for refers to section if, let's say, I have 100 sheets, ranging from Sheet1 to Sheet100?

 

[GlennUK]

What are you going to be using the name for? Can you show an example formula that would use your defined name?

 

[Yahya]

try to use this
='Sheet1:Sheet100'!$A$1

 

[superclass12]

Hi All,
I am trying to execute the following formula:
=SUMPRODUCT(N(INDIRECT("'"&MS&"'!A1")), N(INDIRECT("'"&MS&"'!A2")))
in which MS is the name that contains several sheets.

I understand ='Sheet1:Sheet100'!$A$1, but I am trying to find a way to select multiple sheets as themselves, not a specific cell within each sheet.

For instance, ={"SHEET1","SHEET2","SHEET3"}. would choose all 3 sheets as whole, but if I have Sheet1 through Sheet100, I do not want to individually write all their names.

Thanks for your help!