Why not put all data on 1 sheet (instead of 2 sheets).

Than a pivot table can probably help you to do your job.