Pull data from multiple sheets and show only lines that contain data.

[JesseWV]

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

[JesseWV]

Attached is a sample workbook.

I've manually entered the values on the "Daily" sheet the way I'd like it look. I just need it automatically populated from theday of the week ("Mon" and "Tue" in this case) sheets.

Any help would be greatly appreciated.

SalesTrackerSample.xlsx