How to create a report based on a dynamic list of sheets?

AustinAdams 

Excel has some excellent tools for summarizing data (as you know)

It works most readily, most easily, most seemlessly, when you take those summaries from a single database (or maybe from two or more that can be joined by key data elements such as SSN (in the case of employee databases))

What makes it harder is when you're working from separate sheets, such as you're describing here.

But it sounds like those separate, individual sheets come FROM a single data source. So I want to ask, before you solve this the hard way, is it possible to go back in the sequence of events here, to create this "single view of hourly reports" from that original source of data?

[FWIW, during my career, I was the director of the HR/Payroll database for a major corporation, so I've "been there, done that." One of my specialties was being able to use SQL to extract data from an IBM DB2 database, into Excel, where I could use Pivot Tables and other Excel tools to summarize raw data into the form of useful management reports. There were occasions when the IT professionals were relying on brute force programming routines to summarize data, and I was able to use built-in Excel functions to accomplish the same results, faster, more reliably.]