EXCEL 2007: best method to auto populate rows on multiple sheets from a main sheet?

[spex]

What I’m attempting to do is copy rows to other sheets depending on what value is in column A. This “admin” sheet will be constantly updated, and have tried using pivot tables, but wasn’t able to make changes once the pivot table was made. If a new row is entered on the “admin” sheet, I need it to go to its respectful sheet by the value in column A (i.e. sheet BILL, Sheet CREDIT, Sheet LOAN..etc) the information on these other sheets will be used in other future formulas, and making the cells = what was on the admin sheet doesn’t work for what I want.
Once the information is transferred to a new sheet, I want to have the data sorted by column C (interest rate), but still be able to auto sort if a new entry is made on the admin sheet.
I have been looking into macros, and VDU’s, but have no exp in those, and have been on the forums for the past 3 days now looking, copy pasting, and messing my workbook up…so I decided to just finally ask.
The biggest question I have is what should I be using a macro or formula? Most of the fixes I have seen are already made by the generous people that take the time to make the codes, but I really would like to know if there is a cheat sheet to know how to make the code the way you want?

[arlu1201]

Is this solved?