On Feb 14, 1:13*pm, Jackie wrote:
You are my HERO. *Thank you! *
Jackie

"CurlyDave" wrote:
Experiment with the Indirect function, you will be able to reference
another worksheet by what ever worksheet name in in a cell

Here is a very simple Sample
http://sites.google.com/site/davesex...ples/UsingIndi...

More on Indirect Functions can be found here...
http://www.contextures.com/xlFunctions05.html#RefSheet

It's hard to describe, not knowing what the layout of your worksheet
is. You can loop through the sheets with VBA to get the sheet names
and values from all the other sheets.
Check out this example, enable macros when you open the Workbook.

http://sites.google.com/site/davesex...attredirects=0