Excel Macro

I am in need of an Excel Macro for automated formatting that can handle less than 100 rows of data per tab, over multiple tabs. The macro should be able to perform this function on all selected tabs. Specifically, I need the macro to automate row insertion and deletion based on a value in the sheet. Ideal skills and experience for this job include proficiency in Excel Macros, VBA programming, and knowledge of row manipulation. If you have experience with data analysis and report generation, that would be a plus.