Looks like the answer to all of those questions we field that go something like this:
"My company keeps track of monthly [insert data description here], where each workbook has data for one month, and workbooks are named [insert naming convention here]... all of the workbooks are structured the same, but I want to look at trends for the the past quarter, past year, and past 3 years. How can I do this?"