Conditionally Populating a Sheet from Mulitple Sheets

[Odysimus]

What I have is a workbook that holds records of transactions for multiple entities within a corporation, with separate sheets for each calendar year. For reasons beyond my control different entities have different fiscal years. What I need to do is to have a cover sheet that can be populated by the other sheets for a given fiscal year. Preferably I would like to be able to select a year and have the list be re-populated accordingly. Attached is a copy of the draft I'm working on. For each year I have a column that determines the fiscal year. It is currently populated with some test data, and the ranges of the functions are arbitrarily set.