Excel 2007 : Summarize data from multiple worksheets with multiple criteria

I have a summary tabs and about 200 detail tabs. In column A of every tab, you pick titles from a drop down menu so the names are consistent throughout. Each detail tab has a company number, 1000, 2000, etc. The summary tab will have all the possible titles from the drop down menu in column A and have all the company numbers across the top. Rather than have to link up each column to the individual detail sheet and have a sumif if it matches the title name, I want to try to find a formula that would match the company number that would be listed on each detail tab and the predetermined title name and then put the amount in the summary tab so I can just drag this formula across/down my summary sheet.

So my summary tab would have the company numbers across the top and the titles along column A. If the detail page matches the company number and has the same title, it would drop in the amount. Each detail tab looks like the summary tab except with only one column of data

I was able to do this using index and match when the data was on one sheet but now that I have expanded by using '1000':'3000' for example, it doesn't seem to work properly. I also need to use IF(ISERROR to get rid of the #N/A if a certain detail sheet doesn't have that specific title so I can sum each company at the bottom of the summary tab. This was also working ok when it was all on one sheet so I need to figure out what I am doing wrong and if you are able to use this formula across multiple worksheets! If there is a better formula to use to achieve this goal please let me know. I am new to these sorts of more complex formulas so any help would be greatly appreciated! Thanks!