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?

@Contro:
Ok, I'll ask the 'big' question once, and please don't repeat the confusing flurry mesh of info you gave above: What goes into this black box, and what is the expected output? (IOW, what is it to be used for)

-Ath (February 09, 2020, 03:25 AM)

you are totally right Ath.
That's the point.
I have tried to explain to Shades. Perhaps you may accomplish there.
 :P

-Contro (February 09, 2020, 11:37 AM)

Well, all that you have done is what I explicitly asked not to do: You've added a mishmash of unrelated and useless words that say absolutely nothing about the issue you are trying to resolve. And on top of that you even used 3 posts to do that... >:(
To add insult to injury, you talk about using ahk to do something for you because Excel is 'too big' for you (to handle?).
What kind of help are you expecting?

1 google search gave me enough information to find this makeuseof page (select Not Now in the red page-blocker when using a decent browser with an ad-blocker), providing not 1, but 3 step-by-step procedures to accomplish what you ask. With the standard product, so no utilities needed, only a rather simple skill: google

As you forgot to mention what Excel version you are using, I assume you have a decently modern version that has a ribbon (Excel 2007 or newer).