Summary worksheet referencing 100 worksheets
I have a summary worksheet with a table of data that references the same
cells in about 100 worksheets. Is there a way to reference the worksheets by
other than worksheet name, e.g. by a number in the order that they appear in
the workbook?
This would save having to add the worksheet name to each of several cells in
the list.
Thanks, Kris
|