I have 13 subsheets that need to have their data put onto a master sheet. The header in A1:M1 is the same in every sheet, the data below though is always changing. What I need is to be able to clear the contents of everything below A1:M1 on the master sheet then paste all of the data from every subsheet onto it. There isn't a defined maximum number of rows on any sheet.
The more complicated way...if it's possible it would be great if everytime one of the subsheets is updated it automatically updates the master sheet. This workbook keeps track of maintenance and every subsheet relates to a different production line. What would be ideal is when the production line adds their issue to their subsheet it adds it to the master list, then when one of the techs updates the issue with "complete" on the subsheet it finds that data on the master list and updates it with the new data.
I have a small simple code for right now that is copying the last row used and pasting it to the master sheet but that doesn't work for when issues before the last row used get resolved.