Select table rows based on is not blank

I have a workbook that collects daily sales and payroll data. The worksheet "DataEntry" is a data entry worksheet with several tables. I have a macro that copies these tables and pastes their contents into tables in other worksheets. There is one table that frequently has rows that shouldn't be copied. I have not been able to figure out how to conditionally select rows, or delete excess rows.

I have attached a sample file. The code is included in module 2

I am trying to move only the rows that have a value in the employee column.

My current code sorts the table on the employee column to move the empty rows to the bottom. I need to know how to delete those rows, or only select the ones that have values in the employee column.

Because my data is in a table my very basic VBA skills fail.

thanks!