Macros to lookup column and row headings and extract data

[ramliedt]

Hello,

In the attached spreadsheet I have a list of customers along with the assoiated legal firms. Each tab represent a different month. The customers are listed in rows and the legal firms are in columns across the sheet. However, the customer and legal firm list is different for every month. I want to create a summary sheet which will keep a running total for each customer and legal firm. Is there a macro that can scan through all the sheets in the workbook and extract all the customer names as well as all the legal firms and drop them in the summary tab. I dont want to have duplicates as some names will appear in mulitple tabs. Then I think I will need a vlookup that will sum up the amounts for each customer and legal firm. If there's a macro that can sum up the amounts for those names, that would even be better. Any help anyone can provide me would be greatly appreciated!

Thanks!