Merge Append all sheet

[shyam]

''''''''Hello guys please help me to get result sheet as shown in follows
''''''''''''please help me to find the result as shown as folliows
'Sheet1
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7
a1 b1 c1
a2 b2 c2
a3 b3 c3
a4 b4 c4
a5 b5 c5
a6 b6 c6
a7 b7 c7
a8 b8 c8
a9 b9 c9
a10 b10 c10
a11 b11 c11
a12 b12 c12
a13 b13 c13
a14 b14 c14
a15 b15 c15
a16 b16 c16
a17 b17 c17

'Sheet2
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7
a1 b1 c1
a2 b2 c2 d2
a3 b3 c3
a4 b4 c4
a5 b5 c5
a6 b6 c6 d6
a7 b7 c7
a8 b8 c8
a9 b9 c9
a10 b10 c10
a11 b11 c11 d11
a12 b12 c12
a13 b13 c13
a14 b14 c14
a15 b15 c15
a16 b16 c16
a17 b17 c17 d17

'Sheet3
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7
a1 b1 c1 d1 e1
a2 b2 c2 e2
a3 b3 c3 d3 e3
a4 b4 c4
a5 b5 c5 d5
a6 b6 c6 e6
a7 b7 c7 d7 e7
a8 b8 c8
a9 b9 c9
a10 b10 c10 d10 e10
a11 b11 c11
a12 b12 c12 d12
a13 b13 c13 d13 e13
a14 b14 c14
a15 b15 c15
a16 b16 c16 d16 e16
a17 b17 c17



'RESULT_SHEET
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7
a1 b1 c1 d1 e1
a2 b2 c2 d2 e2
a3 b3 c3 d3 e3
a4 b4 c4
a5 b5 c5 d5
a6 b6 c6 d6 e6
a7 b7 c7 d7 e7
a8 b8 c8
a9 b9 c9
a10 b10 c10 d10 e10
a11 b11 c11 d11
a12 b12 c12 d12
a13 b13 c13 d13 e13
a14 b14 c14
a15 b15 c15
a16 b16 c16 d16 e16
a17 b17 c17 d17

 

[joel]

I think we ned some clarifications to get this macro correct the 1s
time.

1) How do you know which rows on each sheet get combined. Is it alway
row 2 on each sheet that gets combined or is there a header column (I
number) that is usd to determine which rows on each sheet get
combined.

2) Are we merging the data so each row on the resulting sheet get
appended after the last column or are we using the header row (row 1) t
determine which column the data goes into.

3) If there is data on more than one sheet in the same column and ro
is the data always the same? If not which sheet should we use on th
Results sheet