Append data from multiple excel files with respective file name

Hi All,

I have 95+ excel files in one folder. I want to append data of all 95+ excel files in to one file on everyday as these 95+ excel files are updated frequently. I want to append data of all 95+ excel files in to the next available row in a file. So the code should do the following task.

1. Ask for the path (browse) to select a folder which has those 95+ excel files saved in it.

2.Take data of all 95+ excel files one by one and append it to one file with their respective file name to one file say "Consolidation.xls(x)"

3. All the rows & columns should be an autofit

4. If blank row existed in append data, it has to be delete/remove automatically

All 95+ excel files and my "Consolidation.xls(x)" file has same number of columns and titles. I am beginner to VBA. Please help me to build a code for this.

Regards,
Vijay