Pivot Table - Can Data Range be on multiple worksheets?
 

I am trying to compile all the data from distinct worksheets into 1 pivot
table. Each worksheet is a day. Within this tab, I am tracking different
subjects (in rows) and their number of errors, number of successes, and
totals. Each tab has the same format and amount of data.

I have tried different ways, but i am getting "Range is not valid" error.
Does anyone know how i can compile the data from all the worksheets into 1
pivot table?

Thanks!