I'm sorry but it is difficult for me to picture what your data looks like and how it is organized. Would it be possible to replace the confidential data with generic data? I wouldn't need all the rows on each sheet but just enough for me to get an idea. Also it isn't clear which data in which sheets you want to compare and which sheets you want to compare to. If you are able to attach a desensitized file, please explain in detail using a few examples from your data and referring to specific cells, columns, ranges and sheets exactly what you want to do.