combining multiple worksheets
 

I hope that I can explain this.

Background: My company makes a bunch of different products (AKA: Formulas).
Each product consist of various codes (there are 403 codes). I keep track of
all of this. We have 6 different spread sheets (1 for chemicals, 1 for
paste, 1 flux etc). and in each spread sheet there are 2 tabs (1 for North
America products, 1 Asia Pacific Products).

Problem: We are in the process of eliminating a bunch of formulas, so I need
to combine all of these spreadsheets and come up with a list of any codes
that have less that 15 formulas associated with that code. Any code that has
<15 will be discontinued. If i try to combine the two tabs, there isn't
enough room going across. How can I combine all of these spreadsheets, Your
help is greatly appreciated. Would access help?

Spread sheet looks like this
Code Formula 1 Formula 2 Formula 3
1 50%
35%
2 75%
35%
3 50% 25%
30%