I have 2 excel spreadsheets. 1 of them is my MAIN sheet that I use every month. It has many other tabs and formulas that interact with each other.

The other sheet is basically the same thing, just has more rows/data. I need to add those rows/data to my main sheet without breaking formulas (thus I can't copy/paste the entire sheet).

So right now, I'm stuck with about a days worth of work inserting rows into various places all over this main sheet to match the rows in the new sheet. Once all the rows are in, I can then copy/paste without breaking formulas.

Does anyone know of an easier way I can do this process?