I have a spreadsheet that has a worksheet for every day of any given month, is there a way that I can create a pivot table that will include the data range for every day?

I've been looking but no luck as such.

Cheers up front