It might be better to combine all the data on one sheet with continuous dates, and then if you want to see the relevant data for one month you can have another sheet where you can select the year and month from drop-downs and the data will be displayed automatically.

Hope this helps.

Pete