Thank you. It worked for most, but stopped pasting at row 203, with about 10
tabs left to go. It did most of the work, so I saved a lot of time.

Thanks, Cindy


"Ron de Bruin" wrote:

Start here
http://www.rondebruin.nl/copy2.htm

Or maybe create links
http://www.rondebruin.nl/summary.htm

--

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


"Cindy E" wrote in message ...
I have a workbook with about 150 tabs, each named for a particular customer.
I need to consolidate the data by gathering row 113 from each sheet to a
summary sheet. I read the posts on linking multiple cells, but my ability to
adapt a macro for my needs is very limited currently.

I appreciate any help I can get.

Thanks,

Cindy