All - Having problems with creating an unusual reference.

I have a workbook which contains a template that users will copy and
rename as many times as they need to e.g. Analysis Template becomes
Analysis 1, Analysis 2, Analysis 3, and so on. I've created a summary
page which collects the highest level results from each of these
worksheets (one row on the row per worksheet) - but am having problems
telling excel which worksheet to go to find the value.

What I need for this summary page is for Excel to recognize that I need
'Analysis ' and ID number depending on the row of the summary & '!Cell
reference' - I could go through and do each row manually - but I am
distributing this workbook to several different user groups each of
which may have any number of different template copies - so it needs to
happen automatically based on the number of copies they create.

Any thoughts?

Thanks -
Matt


--
mattbloodgood
------------------------------------------------------------------------
mattbloodgood's Profile: http://www.excelforum.com/member.php...o&userid=24999
View this thread: http://www.excelforum.com/showthread...hreadid=385267