I don't really understand what you are trying to do. You can use the
sheet name as a variable to specify what sheet to pull the data from.
Suppose cell C2 contains the name of an existing worksheet. The
following formula will return the value in cell A1 from whatever sheet
is named in C2.

=INDIRECT("'"&C2&"'!A1")


Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)


On Thu, 25 Sep 2008 10:19:04 -0700, RedFive
wrote:

I am trying to consolidate cells from different sheets into one master sheet.
Was wondering if there is a way to have a column that displays what sheet
the information came from. Thanks