Anyway to combine multiple sheets into master?

Hi,

I have a workbook with 12 sheets and each contains data for one month of the year. Each sheet has the companies who have opened an account with the department I work for. This workbook is constantly updated and new rows are always being created for many different months.

My question is if there is anyway to have another sheet which will take all the data from the 12 different months and combine it into a masterlist of companies? My stumbling block is that when I insert new rows, the masterlist doesn't adjust for the new rows/companies and the equation/code just ignores all of the new rows.

Thank you for the help!

have you thought about having one pivot table that looks at the 12 sheets together, this will give you a list of unique names. Use this list as the left hand column in a sumproduct table, however the formula will be 12 different sumproduct eqations added together. there is probably a better way...

Bob