First, thank you for your help.
I created a macro that is used with many different workbooks and I use the
worksheet name as criteria for one of the formulas. Is there a way to add
some code that will get the worksheet name of the open workbook and put it
into a formula or function? My workbooks contain varying amounts of
worksheets, one workbook has two sheets another has four and another has 12.
Some of the names of the sheets begin with the word summary, these sheets I
don't include in my formula. Right now I go into my macro and manually change
the criteria but this sometimes a long time. Can something like this be done?

TIA
Joe