I have a worksheet which is same for 9 offices named STAT 1, STAT 2 etc. when i get all these filled up worksheets i want to place them in one folder with a blank file named "Template". In the template sheet i want a macro that will open the STAT1 , STAT 2 etc copy all the rows into the "template" worksheet. however columns H to J col U are to be left out from the rows that are copied.
during the copy process data from each STAT1, STAT 2 sheet should be pasted where the data from the previous one ends.
Could someone kindly help. all the STAT sheets are of the same format and layout.