Thanks for the link. It answered questions I haven't yet asked but I dont
see that it answered the one I did ask. OR maybe it did and I'm too green to
recognize it.
Thanks for giving it a go.

"Gord Dibben" wrote:

See Ron de Bruin's site for code assistance.

http://www.rondebruin.nl/tips.htm

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 11:34:03 -0700, Mac wrote:

Is there an easy way to gather from various locations, a number of individual
worksheets into a single new workbook.

Any help would be greatly appreciated.