Compare several worksheets to 1 worksheet in Excel 2016

[DThib]

Hello,

I am looking for code to take a comparison of one worksheet with all the data to the 7 worksheets with the original data.
Can someone help with a code that allows me to place a phrase with address of original next to the comparison or even onto a new worksheet?
All the data is in 1 workbook.
I would need to match several items in the column it finds in the original.

Help!

DThib

 

[Vbagreenhorn1]

i'm sure someone can help you whit that, but provide us with more info.

 

[DThib]

Each worksheet is a data run from an instrument.
Columns A-M have data.
The combined worksheet has all the data from the 7 runs.

There are column headers
I can give you a sample of the type of data if that will help.

 

[DThib]

Here is a sample of what is on all worksheets

[

Sample Group	Sample	Assay	Wells	Dilution	Concentration	Signal	Signal Mean	Signal CV	Calc Conc.	%Recovery	%Recovery Mean	Calc. conc. Mean	Calc. Conc. CV
Standards	S1	IL-1as	A01	10	3360	2678	259	4	3539.22	105	102	3424.86	5
Standards	S1	IL-1as	A02	10	3360	2515	259	4	3310.50	99	102	3424.86	5
Standards	S1	IL-2aq	A01	10	60000	3883	3835	2	60889.44	101	100	59988.99	2
Standards	S1	IL-2as	A02	10	60000	376	3835	2	59088.54	98	100	59988.99	2
Standards	S2	IL-1as	B01	10	840	664	660	1	804.80	96	95	799.08	1
Standards	S2	IL-1as	B02	10	840	656	6645	1	793.37	94	95	799.08	1

<tbody>
</tbody>

DThib