Raw Data Consolidation

I've got a large file with identically structured tabs, one for each dept. The tabs are structured for projects and phases, whereby titles and hours worked are input by month. I have a data tab that is pulling back all of the title data for each dept, project, phase, month, etc. Due to the other data in the columns on each dept tab, I've had to directly reference the cells on my data tab.

What I'm trying to do is create a consolidated report from the data tab that only shows the data for lines with titles included. That way I don't have to show blank-line data. I would normally just create a pivot table, but I also need to make subtotal calculations off of the report (Fees & Avg Rate). Thus, I think a pivot table is out of the question.

I've attached a sample spreadsheet showing the data tab and sample report structure. The headers for the rates and months will change based on the date the user selects to start.

My main questions are as follows:
1. Can I create a report form this data tab that only shows relevant lines?
2. Would it be easier/possible to just rig the data tab to automatically hide blank lines and unhide them as they become relevant?
3. I also need to figure out a way to calculate the sumproduct for the Fees (highlighted yellow on report tab).

Let me know if you have any questions. TIA for your help.