Merging multiple workbooks that contain identical tabs

I fixed the problem about the rows not copying correctly by altering the code slightly, by making it look up the C column not A.

But there is one problem still remaining, if one of the worksheets doesn't have any data the last row of the header is copied and put into the master, how can i avoid this?

I need to be able to because only certain employees fill out each worksheet, one may fill 20 of the possible 22 worksheets while another may only fill one of 22.

thanks so much.