It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific
cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.