Hi Maryam...

What still I can't figure out, how to know that (for example) :
1. Under METER header, row .... is to be copied
2. Under DEVICE header, row .... is to be copied
3. Under PROG header, row .... is to be copied
.
.
.
105. Under BLA header , row .... is to be copied
106. Under BLU header , row .... is to be copied

Because I thought that in each sheet of your 15000 sheets,
each has the same 106 header name across the column
where under those 106 headers you want to copy one specific cell,
so there are 106 values to be copied.

Example: (as you said different layout in each sheet - but I assumed that all the 106 headers name will be there).
In sheet-1-of-15000, header METER is in cell A1, header DEVICE is in cell C1, .... ----> header 106th is in cell AA1
In sheet-2-of-15000, header METER is in cell G1, header DEVICE is in cell P1, .... ----> header 106th is in cell ZZ1
In sheet-3-of-15000, header METER is in cell AAA1, header DEVICE is in cell Q1, .... ----> header 106th is in cell AC1
In sheet-4-of-15000, header METER is in cell AK1, header DEVICE is in cell MM1, .... ----> header 106th is in cell S1
.
.
.
In sheet-15000-of-15000, header METER is in cell D1, header DEVICE is in cell KL1, .... ----> header 106th is in cell X1


it should search for Meter Number
Yes I understand that.... search for the header named METER, so this is the column.
But the thing which I still don't get it is how to determine for the row : (for example)
In sheet-1-of-15000 :
it is row 100 under header METER (so, A100) is to be copied
it is row 25 under header DEVICE (so, C25) is to be copied
.
.
.
it is row 349 under the 106th header (so, AA349) is to be copied

In sheet-4-of-15000 :
it is row 5 under header METER (so, cell AK5) is to be copied
it is row 27 under header DEVICE (so, cell MM27) is to be copied
.
.
.
it is row 123 under the 106th header (so, cell S123) is to be copied


So... while the header name can be search with :
IF in sheet-1-of-15000 is found a text "METER" ---> result : found in cell A1 (column A)
THEN how to determine that it is row 100 (in column A) to be copied ?


Please correct me if I'm wrong