Try this add-in
http://www.rondebruin.nl/merge.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"BNT1 via OfficeKB.com" <u19326@uwe wrote in message news:8afb388a0ea77@uwe...
Hi

I have 20 workbooks, all the same, with one summary sheet in each named
"Summary" . The "summary" sheet is the first sheet in each workbook
What i require is one new workbook, that adds all those summaries together
File for all those workbooks is J / Distribution KPI / "then the appropriate
workbook name"
Range in the "summary" sheet is A1:N44, (this range does include header row
and there are a few blank rows used to break-up the data (formating)
I have limited macro knowledge, but i can copy/paste or tweek if not too
complicated
Hope this makes sense

Any suggestions

Excel 2002
Regards

Brian

--
Message posted via http://www.officekb.com