Try Pivot Table..Refer http://www.contextures.com/xlPivot08.html

If this post helps click Yes
---------------
Jacob Skaria


"Dan" wrote:

In one workbook, I may have several department sheets with many account
numbers by month. However, not all departments will have the same accounts.
For example, department A may have account 1,2,3, while department B may have
accounts 1,3,5. The goal is to have a summary sheet that contains all
accounts by month. I could do this manually with only one or two workbooks,
but I will have more workbooks than I have hours.