Dashboard report from multiple workbooks - user selects quarter (ex. Q1 2011)

I’ve been approached to create a dashboard report from multiple workbooks. Data is collected for different "Categories" for facilities (health). Each "Category" is tracked in a separate workbook – with a separate tab for each facility’s quarterly data. They’d like to create a Dashboard Report that contains data from each Category for a singl facility for a selected quarter. I need the Dashboard Report to:

1) allow the user to select the quarter the report will be generated for
2) each Facility should have its own dashboard report on a separate tab

Assumptions: all workbooks have the same facilities and quarters. The range of data and number of questions are different for each Category. Example work books are attached: a) Category 1 b) Category 2 c) Dashboard Reports

I am looking for a level of effort estimate, the skills needed (marcos/VB/MS querying) and steps needed to complete the project.

Thanks so much in advance,