Hi Vasant - Glad it's not just me :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Seasons Greetings and Very Best wishes to all :-)
----------------------------------------------------------------------------



"Vasant Nanavati" vasantn *AT* aol *DOT* com wrote in message
...
Julian; unfortunately I haven't the foggiest understanding of what you want
to accomplish. What do you mean by "returning Value 1", etc.?

Are you just trying to add the same cell across worksheets? If so:

=SUM(Sheet1:Sheet3!B12)

will do it.

--

Vasant


wrote in message
...
I have six workbooks with about 75 tabs each. I want to
return the same values from each of the different tabs,
consolidated on to one tab. Right now we are doing it by
clicking the cells, but it is taking way too long and too
prone to error.

Instead, I need a formula (macro maybe) that will help me
return those values across all the different tabs.
Value 1: Is generally unique, but may exist more than
once, I want to see it returned each time (so if it
appears 3 times, I want to see it three times), because
how it relates to Value 2 is very important.
Value 2: Is unique, but must be kept in connection with
value 1
Value 3: Is unique, but must be kept in connection with
value 1

any ideas without me learning VB in the next 24 hours?




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003