You'll need to write your custom logic with the help of SharePoint Timer job. It can iterate through all the subsites and list and then create a formatted report for emailing. If you need to do this by designer then:
Create a loop which will run infinitely containing a pause of 1 day before executing again. Then do all the logic writing with the help of REST API