Aggregating Data from Different Workbooks that have multiple worksheets

[Tikipagla]

I receive reports from different business areas. Each business area sends one file with multiple tabs (which can vary from month to month), each tabname is based on an errorcode, and the tab contains the individual errors. So depending on the month, the business area may or may not have the same tabs, ie, same errorcodes.

What I am trying to do is to read each file, and create an output file, each tab describing the business area, and each sheet containing the count of the different error codes experienced by the business are during the month.

I am attaching the files to make things clearer. The file Business_Area_1 contains tabs which I randomized to make my problem clearer. Each month, the errorcodes may be different, and based on whatever errorcodes were reported for the month, the Error_Breakdown file will have to name a tab for the Business_Area, then select that tab and list only the applicable errors in Column B, whereas Column A will list all possible errorcodes.

Thanks for any help....its more complicated than I can manage at the moment.

[Tikipagla]

any ideas?