Quote Originally Posted by ravichandavar View Post
Yes all files are excel files, and i want a consolidated data in one worksheet including the Headers.i.e all contents of the files.
1. Is the structure for each file identical (same headers in the same order)?

2. Do all the files consist of only a single worksheet each?

3. Is the order the files are consolidated in important (in other words, is the final order of the data important)?

4. The Headers... are the all on Row 1 only?