Trouble with filtering/hiding data excel 2003

[janet824]

I have a spreadsheet that lists my locations top 20 customers (this is for work). The purpose of the file is to have a more complete profile of the customers. I have a few different categories (ex: Income, Company Profile, Employee Benefits, and Bank Services) and each category has a few sub categories (ex: Company Profile has Number of emp, Annual Sales, Industry, Years in Business, etc) What I'm trying to accomplish is to have a drop down or different buttons that will pull one category with all it's sub categories and correlating data. I was able to accomplish this by creating buttons that would show each category and one that will display all categories. I attached macros to each button. The steps were to just hide and unhide columns. This works fine until you need to add a new column. The macros that were created all need to be redone when a new column is created. I also had to put the buttons in column A so that leaves less room to see the data. I would like to be able to put a drop down or buttons above the data. I was unable to do this because some of the buttons would be hidden if certain columns were hidden. I did use the freeze pane option to lock the customers names in place. I've looked through many websites and could not find something that would help. I'm not really sure if I should be searching macros, filters, formulas, or something else. The two problems I'm running into that I need help with is the ability to add columns and have the data be pulled for the correct category. The other is that I would like to be able to put the buttons (or drop down if it is possible) above the data. I hope I'm being clear. Let me know if you need clarification on anything. I would really appreciate assistance on this. Thank you in advance.