I'm trying to help solve issues/questions, because that is what I like to do, but with your questions/issues the hardest part is not finding the solution, but to get you to write down
only the facts that are involved in the issue, and the
exact result you want to achieve. Often you are adding a lot of words that have nothing to do with the issue, making it nearly impossible to help.
I'll retry to get the facts clear, please give consise answers to these questions:
- What is the input? Currently I suspect there is an Excel file with several sheets
- Do all sheets have the same columns/data?
- Can you provide a sample file?
- What is the output you need?
- All sheets combined into a single sheet in a new file?
- All sheets combined into a new sheet in the current file?
- All sheets combined into the first sheet in the current file?
- All sheets should remain in the file?
- All sheets from sheet 2 should be deleted?