Collating Reports

[Rustik]

I am new to Excel, and do not know very much about it at all.
I have a project to deliever to my boss, and for a noob i have made great progress, but i am now stuck.
I have 15 tables on a work sheet.
Each table represents a department where i work (15 departments).
Each table has a set of results for each week in the year, named as week 1, week 2, etc, (52 rows, around 10 columns per table).
I would like to be able to select a series of week numbers for each table (department) and have it collate the information (generate a report) for the selected week numbers, for the relevant department. I would only want to collate statistics for one departrment at a time. I would like the information to copy to a blank work sheet which can be viewed by the relevant manager.
Please, can somebody help me as i have no idea where to start? Thanks in advance.

[shg]

Welcome to the forum.

You can merge all the date into one table (perhaps adding a column for department), and then use AutoFilter (http://www.contextures.com/xlautofilter01.html), AdvancedFilter (http://www.contextures.com/xladvfilter01.html), or a Pivot Table (http://www.cpearson.com/excel/pivots.htm) to generate the report.

These are three very powerful tools. AutoFilter is drop-dead simple to use; when you run out of horsepower there, you can switch to AdvancedFilter.