Fill data in the Excel table

From sources in the form of diverse files-tables (approximately 20 pieces) with different types of data, according to the criteria had been collected information and reduced to a single report on 68 columns and a list number of more than 1500 lines.
For example, a sample was carried out with different conditions, as list information in the sources was not brought to a single structure.