UCopy the data from Sheet1 to one Master file in to Diff sheets.

Vjth Posts 1 Registration date Friday September 4, 2015 Status Member Last seen September 4, 2015 - Sep 4, 2015 at 06:23 AM

My first question !

Ok. I am trying to find a macro which can help me in coping the entire Sheet1 from one work book and copy it to another sheet of work book .

So my conditions/available data are as follows

1)I have 32 Work books which consists of data from 32 Countries each.
2)The first sheet of work book from 32 excel files is what i should copy to a new workbook to one after another sheets which i cal here as "master work book" to make a report for country wise for circulation .
3) Data should be copied to next available sheet of " Master Work book". I mean each country data should be in separate sheet .
4) Each sheet should get renamed as the Name of the Work book it copied .
5) I should be able to select the Folder where the entire data is saved as each month the folder gets changed .

Hope the details are sufficient .

Can some one help me out ?