hi please help me.
i want to merge consolidate data from some excel files(workbooks) into one workbook. i tried some macros from internet but they are merging all 3 sheet data into single sheet, which makes scrap.
but my requirement is
1, i have 17 workbooks with 3 worksheets in each. in every workbook there are 3 sheet named "ALPHA" "BETA" and "OMEGA". workbook names are changing frequently
2,i want to merge all workbook in one master workbook where i get 3 sheet. i.e. if i open "ALPHA" i can see all 17 workbooks alpha sheet data only.
3,one more thing that every sheet have a same format and data TITLE. this title data should not copy every time as its required only first time.
4, information on 3 sheets are totally different. i.e. alpha has a weekly test score info of school student of all grades, beta has info of student with sport skills of all grades and omega has info of students project skills all grades.
please any one can help me, as i dont know anything about MACRO and VBA , i have to do this things manually every time which is too much time consuming.
thanks in advance.