Hello

I'm new to the forum and have just started understanding how macros work. I have a complicated problem that i need help with.
I'm doing research involving 3 type of detectors. Every experiment is done 3 times with all detectors running simultaneously.
Example of the sheet and tabs are shown below.
Now my question is someone can help me with a macro to find common compound names (column H) that occurs in all "MS" tabs, EXP1 = experiment 1 and so on.
Some compound names can be found in all 3 experiments while some can be found in 2 or just 1 experiment.
The first thing i need is the macro to find first all the triplicates in for example Exp1 MS, Exp2 MS and Exp3MS and paste the rows in "C(1)MS" tab
C(3)= common in 3 experiments. I also need to know from witch experiment the names came from.
If possible take the copied rows and organize them as in example 2,3,4 in the C(1)MS, C(2)MS and C(3)MS tabs. Note that in example 2 and 3 column P is sorted from largest to smallest Average %Area. This examples are just my way to organize the data so that i can create charts from column M and P, if you have a better suggestion please tell me.
The important thing is that i well have almost 100 of this sheets and they well have different amount of rows in the "*EXP*" tabs so please take this in to consideration.
I know That this is a complicated macro but it would really help in my project and save me a lot of time and because this is an ongoing project a well have more question later on, all help is much appreciated.

I'm not sure how to upload an example file but i well if it's needed.


Example1.jpg
Example of experiment 2 data from MS detector

Example2.jpg
Example 2, triplicates compound names found in 3 out of 3 MS experiments

Example3.jpg
Example 3, duplicate compound names found in 2 out of 3 MS experiments

Example4.jpg
Example 4, compound names found in 1 out of 3 MS experiments and Chart based on column M and P in example 1