I have a macro I am trying to get to work. It's in a workbook with 7 worksheets labeled Greschner, Vodnick, Mello, Goodrich, Fasino, Cooke and Canavan. The columns A-M are identical on all worksheets. Problem is when I run the macro which makes a new worksheet labeled COMBINED, it does not copy everything from the other 7 worksheets, specifically, the first worksheet Greschner copies fine, and the last worksheet Canavan copies fine, but the worksheets in the middle are all missing their LAST ROW of data. I cannot tell why this is happening. I have attached a notepad file of the macro.