Perhaps something like this, Andy?
http://www.vbaexpress.com/kb/getarticle.php?kb_id=151

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


Andy wrote in message ...
Hi

We are buying a company and I need to create a stock spreadsheet from
their
workbook. I would like a single sheet containing the information from
about
25 of their sheets. They have one sheet per type of stock item (all in one
book), so some of their sheets have 1 row and some have 50! Bearing in
mind
that some of the rows are hidden (which I don't want) what is the easiest
way to consolidate their information into a single sheet, containing all
of
the info from the individual sheets?
Cheers.
Andy.