Copy Data from multiple sheets and paste one below the other in a master sheet

[JOHN007]

I need code which can copy data in multiple sheets and paste in a master sheet. I actually have ~500+ sheets which need to be pasted (accumulated at one place)

My excel looks some thing like this.

SHEET 1

Slno	name	marks
1	asd	455
6	gfs	3254
7	rgf	252
3	hjf	212

<tbody>
</tbody>

SHEET2

Slno	name	marks
4	ads	110.5
5	akj	262.6
9	yut	635.7
2	bmb	1008.8

<tbody>
</tbody>

and the MASTER SHEET shouid be like .

Slno	name	marks
1	asd	455
6	gfs	3254
7	rgf	252
3	hjf	212
4	ads	110.5
5	akj	262.6
9	yut	635.7
2	bmb	1008.8

<tbody>
</tbody>

. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
If some one could help me out there........

 

[VoG]

See if this helps Consolidating Data from Multiple Worksheets into a Summary Worksheet in Excel

 

[JOHN007]

Still dint solved..

any other methods??