As I said earlier, the data needs combining into one table. Then you can use PivotTables or formulas to create the reports much more easily