Arrange multiple sheets into one workbook

[rchure]

Hi,

I want macro for arranging multiple sheets into one workbook with below condition:

1 - Assign button once i click button my macro will be run. Button name is "Consolidated".
2- Assign path for arrange sheets folder on the sheet of macro button not in VBA code.
3- All the arranged sheets will be save in new excel file.
4- All sheets arrange in ascending order.
5- Default blank sheet will be automatic delete. Only arrange sheets will be visible.
6- Original format of sheet as it is when i run the macro. for example attached is the sheet when i manually moved to the new sheet its format is change.

Hope i will able to understand my points!!! Very Appreciate for your help...!!!!!

Thanks,
Rahul