Advanced PivotTable Help

[HelpMeWithExcelPlease]

Hello all,

I am working on creating a dashboard view that shows the number of defects assigned to each team member over time. What I have are daily tables for the past month. I've provided two example tables below:

08/01 File
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Field Name[/TD]
[TD]BA Name[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]order_name[/TD]
[TD]John[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]file_status[/TD]
[TD]John[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]routing_num[/TD]
[TD]Scott[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]priority_lvl[/TD]
[TD]Mike[/TD]
[TD]Open[/TD]
[/TR]
</tbody>[/TABLE]


08/02 File
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Field Name[/TD]
[TD]BA Name[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]order_name[/TD]
[TD]John[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]file_status[/TD]
[TD]John[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]routing_num[/TD]
[TD]Scott[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]priority_lvl[/TD]
[TD]Mike[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]start_date[/TD]
[TD]Scott[/TD]
[TD]Open[/TD]
[/TR]
</tbody>[/TABLE]

If I have around 10 of these tables, how can I consolidate them into a single pivot table to ultimately build a simple line graph that shows how many fields were in the "open" status for each individual BA over time?

Thank you in advance for your help!