I found a VBA statement a while back that combines a sheet from several different excel files and it has worked great as long as the headers were in line 1 of the data.
I now have a set of work books where the headers is in line 7 and I've adjusted the statement so that it picks up the header...