How to automate copying of data from Excel data files to standardised format template

Every week i get several excel files with the same format, different amount of items for each header though. And i have to paste them all in a blank original. Can this be done automatically? I left a picture for reference so it's clearer. Thanks in advance. http://ift.tt/2rU6fL6 via /r/excel http://ift.tt/2rkvWWe