If you list your sheets in Z, then I assume there is no data in column A of
the other sheets - if there is, do you want to overwrite you list of sheet
names.

Also, do you want to put summation formulas in the consolidated cells, or do
you want to do the addition in code and place just the sum in the cells.

Where is the data area you want to consolidate.

Is it all numbers or are there labels/text. IF so, where is it.

--
Regards,
Tom Ogilvy


"tommasopalazzot"
<tommasopalazzot.1y1l6m_1131225005.5007@excelfor um-nospam.com wrote in
message news:tommasopalazzot.1y1l6m_1131225005.5007@excelf orum-nospam.com...

I have for instance 5 sheets (A,B,C,D,E.,many more in reality) which
contain DATA in the same areas.
Sometimes I need to consolidate A+ B
Other times I need to consolidate A +C+D
.....
Now, I am on the active document Z which is with no DATA on it .

I want excel to consolidate on it A +C+D

I would also like to introduce the inputs(name of the sheets to
consolidate) in the following way:
In A1 I type in:A
In A2 I type in:C
In A3 I type in:D

QUESTION:which is the macro which allows me the flexibility to
consolidate the sheets A,D,C, ETC of my choice?

Many thanks

tom


--
tommasopalazzot
------------------------------------------------------------------------
tommasopalazzot's Profile:
http://www.excelforum.com/member.php...o&userid=27730
View this thread: http://www.excelforum.com/showthread...hreadid=482527