How do I get a macro to search alphabetically by two
categories?

I want to create a macro that can insert a row of
information and formula's into a worksheet.

I have 9 categories of alpha sorted names and 13
worksheets. So I need to find the right category, then
insert the row in its proper location in every worksheet.

I figured I can add a numeric code to the category names
(1,2,3...) to make them easier to search but not sure how
to approach the rest.


Any Ideas?

Todd