I have a couple of hundred excel workbooks, that are all from a template, but saved 'as' for ease of working data.
I want to combine them into one long file, possibly 10K rows... but the header just ONCE..
Less than novice user...
Check this one, which should help.