Greeting,
I have understood your Write a macro that compile CSV data in a folder to an excel folder task and can do it with your 100% satisfaction. Please ping me for more discussion.
I have more than 5 years of experience in Excel, Visual Basic, Visual Basic for Apps