Combine multiple tables into one master table

Hello everyone..

This is my first post here so please be gentle :-) I've looked around the forum to see if this has been asked before but couldn't find any instances - key difference being all existing posts seem to deal with tables in multiple worksheets within the same file where as in my case each table is held in a different file.

As the title states I have a requirement to combine tables held in individual .xlsx files into one large master table.

To elaborate on this - there are 100 .xlsx files and each file contains a table (each table has 6 columns where the header (row 1) is uniform across all 100 tables but have varying number of rows). I need to create one master table that amalgamates all of the 100 tables from all the files into one large table.

Is there an efficient way to achieve the end product i.e. create the master table without the need to open each file>copy all rows except row 1>paste/append in a new table and repeat it 99 times

I am reasonably comfortable in working with formulas but VBA, macros etc are an entirely different matter... but more than willing to learn the ropes.

Many thanks,

-n

The following article may be helpful for you, specifically the "merging a range from selected workbooks" portion.
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

Thanks for the feedback. Remember to change the thread to solved (above, under thread tools).