collecting data from multiple sheets

C

Cindy E

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
 
C

Cindy E

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
 
Top