Add # Of Rows In 4 Shts/compare 2 # Of Rows In Another Sheet

I have some code that consolidates data from 4 sheets in different workbooks into one sheet on a separate workbook. I'd like to add a validation check to make sure that all rows are copied and pasted.

Specifically, I would like to total the # of rows in each worksheet and compare that # to the total # of rows in the consolidated worksheet. On some of the worksheets, the code deletes the header row and/or the last row. So, the count of the rows should happen after those rows are deleted. If not all the rows are copied, a message box should pop up saying "Not all rows copied".

The full code is posted in the linked post below which includes the workbook names, sheet names, etc.:

http://www.mrexcel.com/board2/viewto...112&highlight=