macro : combine results of multiple tables in a folder
 

Hello, all:

I am trying to combine results of multiple excel tables (same table
structures) under one project folder, I would like to have one summary table
created to contain the combined (Append) data and related excel table name,
so later when I add new table to the folder, the macro will only read the new
table and append the result to the summary table instead of redoing all data
table again.

A macro will be great.
--
Thanks a lot!