I'm trying to create a table of sales results to be printed for each day of the week. I want the data pulled from multiple sheets that are named for each day of the week. The problem I have is that for each day not every employee works so there are blank lines. I only want data from active employees to be on the final "Results" sheet.

Graphic1.jpg