Combine x number of excel worksheets in into one sheet on the same workbook
Posted on 2016-09-08
I have an excel workbook with 50+ worksheets.
I need to consolidate all those 50+ sheets into another sheet on the same workbook.
Something like Sheet 2 copied data under sheet 1, then sheet 3 data copied under sheet 2, etc.
More sheets will be added into the workbook. The amount of sheets will not be static.
Therefore the solution for this probably has to be programmatically looping through all existing sheets and copying the data.
I have found solutions in here but not with an unknown number of sheets.
Please if you can provide me with a detailed solution i would appreciate it. (Partial solution or logic for the solution would not be enough for me)