summarize

[breifcase78]

I need to summarize data from 4 sheets in a workbook into one master sheet within the same workbook. The 4 sheets represent different employees and the data are the accounts they are responsible for spread over 12 months. There's a billed, paid and difference row. The summary sheet needs to have all the accounts and all the employees.
Is there a formula way to do this?

 

[BrianB]

Instead of 4 sheets put all into one table with an "Employee" column.
Can then use filters, pivot tables etc. from the Data menu.

 

[breifcase78]

Yeah I was thinking working the "other direction" might be better as well.
Thanks