Macro to merge cells from multiple workbooks into one Master workbook

[psmcltraining]

Dear all

I have attached two sheets one is Biodata other is Master

Scenario:
In biodata sheet users shall fill in their information and mail to me. I will be having a folder which contains 100s of these biodata forms from many individuals.

Now I want to transfer all the data (from specific cells) from all 100 biodata forms into one Master Datasheet to further analyse the data.

The sheet "Master" has the macro which enables me to browse through the computer and give the path of the file (biodata) and it automatically copies the required fields to the Data sheet in Master file.

But it has to be repeated again and again i.e file by file.

I want a macro through which I can give the path of the folder which contains all the biodata forms only once and it will extract the information to the Master sheet from all the files contained in the folder.

Please help

Adnan