I'd copy and paste-values from source to destination, then mark up the source
files as obsolete (by re-naming them).

Alternatively, use formlae to link to the first source, fill down, find the
end of the data range, change the filename in the formulae, fill down, repeat
198 more times, then copy-paste-values to eliminate all of the links.

No quick way that I can think of, not in Excel at least.

If you use Access, you could try to import the spreadsheets into a
common-format database, then export to an Excel sheet. I don't use Access,
so I don't know how cumbersome that might be.


"hkappleorange" wrote:

I have a simple task on Excel but I cannot figure it out. Pls help:-

I have 200 separate Excel files with data all in 3 columns: Region, Month &
Amount. They each has a range of records from 100 to 300 lines each.

I am asked to create a single 3 column table with these 3 fields containing
all data from these 200 tables in separate files.

How many ways we can do this ? Please help.....