Summary worksheet referencing 100 worksheets

K

Kris

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Multiple worksheet summary 4
shorten worksheet name 1
Copy Cells from multiple Worksheets in same workbook. 2
extract data from multple worksheets to a summary worksheet 1
worksheet cross reference 3
Replace worksheet without affecting the referencing formula 1
Cannot copy worksheet to another file 2

Top