I have 70 workbooks, each for different customer containing identical
worksheet - with customer specific data.
How can I get 15 pieces of data from each identical worksheet into one
worksheet in a list format?

I tried consolidate - but either I didn't do it right or it is just as
manual as copy/paste would be.

Thanks