I will create an excel macro that collates data from multiple csv or xls source file

I will create an Excel spreadsheet with macro and VBA that extracts data from multiple source files (xls or csv) and collate it into a large dataset. Or its opposite, i.e. I will create multiple spreadsheet template files, from a large data spreadsheet file containing the large dataset.