VBA to find string and paste to another Sheet

[septimus]

Dear all;
I have data table with following conditions:
+ Row from 1 to 14000.
+Column from A to DTY
I need VBA to make this function find and copy/paste as below:
+ I’ll type the name of string need to find in cell A1, B1,..(can expand later) to cell M1 of Sheet2
+ Be based on my strings, VBA will find in Sheet1.
+ Copy the value found to Sheet2

Maybe it’ll clear with this example:

Sheet1 (source)
	A	B	C	D	……..	DTV	DTW	DTX	DTY
1	ID	Date	IN	Classify	……..	ScaleA	ScaleB	ScaleC	Results
2	M001	011515	2000	A	……..	0.5	0.3	0.2	G
3	M002	011515	2000	B	……..	0.5	0.3	0.2	G
4	M003	011515	2000	A	……..	0.5	0.3	0.2	F
5	ID	Date	IN	Classify	ScaleA	ScaleB	ScaleC	Results
6	M005	011515	2000	A	0.4	0.3	0.3	F
7	M006	011515	2000	D	0.4	0.3	0.3	B
….	….	….	….	….	….	…	…	…	…
13998	ID	Date	IN	Classify	….	ScaleA	ScaleB	ScaleC	Results
13999	M002	011515	2000	D	……..	0.2	0.1	0.5	F
14000	M006	011515	2000	A	……..	0.2	0.1	0.4	B
Sheet2 (result)
	A	B	C	D	M
1	ScaleA	ScaleC	Classify	….	….
2	0.5	0.2	A	….	….
3	0.5	0.2	B	….	….
4	0.5	0.2	A	….	….
5	ScaleA	ScaleC	Classify	….	….
6	0.4	0.3	A	….	….
7	0.4	0.3	D	….	….
….	….	…		….	….
13998	ScaleA	ScaleC	Classify	….	….
13999	0.2	0.5	D	….	….
14000	0.2	0.4	A	….	….

<tbody>
</tbody>

I appreciate all your support
Thank you!!!
Septimus

 

[septimus]

Please help me solve it

 

[My Aswer Is This]

I would like to help but I do not understand what you want.

 

[septimus]

Sorry to trouble you because my English so bad.
I'll prepare clearly content later.
Thank you

 

[septimus]

Dear Sir;
I would like to type the string on Cell A1, B1, C1 of Sheet2 and then VBA will find it on Sheet1 and copy/ paste that column in Sheet2.
In my example, I'll paste string "ScaleA", "ScaleB", "Classify" on Cell A1, B1, C1 of Sheet2.
And VBA will find entire in Sheet1 then copy the value found to Sheet2
Please note that it's not always in same column. (If the answer in cell A5 is "ScaleB" and next row are 0.3 --> It's wrong.
I'd want as below configure

	A	B	C
1	ScaleA	ScaleC	Classify
2	0.5	0.2	A
3	0.5	0.2	B
4	0.5	0.2	A
5	ScaleA	ScaleC	Classify
6	0.4	0.3	A
7	0.4	0.3	D
13998	ScaleA	ScaleC	Classify
13999	0.2	0.5	D
14000	0.2	0.4	A

<tbody>
</tbody>