I can but we need to define the project.

1. Are all the worksheets in one folder?
2. Are there any other worksheets that need not to be transferred in the same folder (therefore the need of a common trait)
3. What's the ultimate use of the *.csvs
4. Do all transferable worksheets share the same line structure? if not are they to keep the same structure?

lest start with that...