Summary tables for workbook containing multiple worksheets

[bellina03]

Hi

I hope someone can shed some light on this for me.

I have a workbook with multiple worksheets. Each worksheet contains tables, which have been named according to the department/team I need to work with on a project. In each table is a series of tasks with a column, Status. In the Status column each task is marked either Outstanding, In progress or Completed.

On the first worksheet, I am trying to create 3 tables (one for each Status) which summarises all the tables in each worksheet. The tables in the 1st worksheet is an example of what I need it to look like and the information I need returned.

Hoping that some can look at the example attached and give me some guidance on how they may go about setting up 3 summary tables.

Sincerely appreciate your time.

Thanks, Lisa