collecting data from multiple sheets
 

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

collecting data from multiple sheets
 

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

collecting data from multiple sheets
 

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