Add all data on 1 sheet (e.g. with VBA) and then use (e.g. pivot table) to get your information.