Combining tables in many sheets to one

[Turnipboy]

I have a number of excel data sheets (single tabbed), they hav
identical column types (no headers just columns of data) of varyin
lengths of data. I want to combine all these table into one (there ar
about 70 tables), is there a quick way of doing this e.g. a macro (a
apposed to copying and pasting each table into one speadsheet? Thanks

 

[Anne Troy]

This should get you started:
http://vbaexpress.com/kb/getarticle.php?kb_id=221
************
Anne Troy
www.OfficeArticles.com

 

[Turnipboy]

Thank you for your trouble, however when I tried this all the excel
files where combined into one book that had severel tabs: one for each
set of data, I would like all the data in the files to go into one
table i.e. in one spreadsheet (tab) in one workbook.

Please do not hesitate to ask if you have any questions.

Thanks.

 

[Turnipboy]

I forgot to mention I would like each seperate table to fit under the
last since the columns are the same but of varying lengths - although
each individual file has columns of equal length (in no particular
order - preferably with no gaps although I am sure that would be easy
to sort out) so that I have one giant table.

Hope this clarifys things and does not confuse even more.