If you're comfortable with VBA (or aspire to be), Ron de Bruin has a
website that you might find helpful:
http://www.rondebruin.nl/copy2.htm

If you have a little SQL experience and where the data is structured
like tables, you can use MS Query (and a little SQL editing) to
consolidate, too.

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=376801