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