Macro to consolidate data from different files in a folder

[macroidiot22]

Hi
I have a template with multiple sheets. One of the sheet is 'consolidate return with macro' sheet where i would like to consolidate data from the different file in the folder. Hence the macro must do the following:
1. ask user to choose the folder where all the files - Annex A1 (can be different names) are
2. Consolidate all the data from Annex A1 to the main template - consolidate return with macro sheet
3. Message to inform user importing is completed.

Can a macro do all these? If yes, pl share the code. Hv been trying to write from scratch from going nowhere. Thanks.