How can I combine multiple workbook into master

[sbv1986]

Hi all:
I have Folder Parent with child folder: 2019, 2018, 2017. Each folder have child folder too: 201901,201902,201903,201904.....201912
It's look like:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Parent[/TD]
[TD]2019[/TD]
[TD]201901[/TD]
[TD]201902[/TD]
[TD]201903[/TD]
[TD]201904[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD]201912[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2018[/TD]
[TD]201801[/TD]
[TD]201802[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD].[/TD]
[TD]201812[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2017[/TD]
[TD]201701[/TD]
[TD]201702[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]201712[/TD]
[/TR]
</tbody>[/TABLE]
I have master workbook in Parent folder: master.xlsm
Now I want to have 02 macro to do that:
Macro1. List all folder, includesub Folder in Parent folder and Create check box for each folder in list
Macro2. When I click check box and run this macro it will combine all files like G001*.xlsx, range(A10:I24) into workbook(master).sheet(G001)
and combine all files like A001*.xlsx, range(A2:AA50) into workbook(master).sheet(A001)

Please help me to do that, many thanks./.

 

[sbv1986]

Please help me