why not add all data on 1 sheet instead of several sheets.

Then you can easy analyse the data (with a pivot table).