Open Files from folder and apply for each loop

[UPENDER Mahato]

Hi All,

I need help to provide a simple code which can fulfill below conditions.

1. Ask user to provide folder name by selecting folder
2. Check if the folder is selected and if clicked on cancel button exit from code
3. if folder selected with files apply for each loop in all excel files in that folder one by one.
4. Copy all workbooks data in one workbook in one master sheet

Please help on this.

Thanks for all yours help in advance.