Is it possible to produce a report that shows all items from all sheets which are due on a particular day?
You sure can! Just open up a report and under When? select the End Date column and the date. Here is a report I just built that will show any task on all sheets that are due on 01/20/16:
