Importing data from multiple files to new file

[agengler11]

Hi all. I am trying to import data from multiple spreadsheets to a new file. I put all of my files in one folder. Each file is exactly the same as far as where the data is. I want the data in the new file to be in a nice clean line by line format. The multiple files have data all over the place.

See example: (Attached File)

I can make my own headers so I would like to keep the A1-Z1 row empty in the new file so we should start populating data with B1

So in short I want to make information on the first file it pulls in to go on A2 B2 C2 .........ETC all the way across
and the next file to go on A3 B3 B3.........ETC

Thanks in advance for your help.