I want to consolidate all workbooks in master workbook.
From daily report file which has Total 14 sheets, I pick up only my teams data,
My Teams Data are in sheets (sheet1,sheet2,sheet3 sheet4 and sheet6 sheet8 ) and every sheets got name also here.
My task is pick sheet1 data Paste in Master workbooks sheet1, sheet2-sheet2 and so on.
every sheets has header here. Sometime in sheet6 and sheet8. there will not be any data. then ignore these .
Below are my code that work for…