The @HansS answer is the best for your problem. Inport all excels from the same folder without headers, (untick fail if schema differs on Advanced tab), remove extra header lines and finaly insert the headers.
What @fe145f9fb2a1f6b wanted to say is for you to read the help guidance at
Please poste your best efford workflow with some data, to get better help from the comunity.