|You will have to use VBA because a formula can not perform any action other than calculate a result within the cell that it resides. A formula can not insert rows, format a cell, etc.|
Before we can offer any code we would need a lot more details such as where are the rows supposed to be inserted, what do you mean by "duplicate that same info on a separate sheet", etc.
Keep in mind that we can not see your spreadsheet from where we are sittng, so the more details you can provide and the clearer you are with your explanation, the better the chance that we can offer a solution.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.