Solved: Combine multiple sheet become one

[reza_doang]

dear all,

i have 1 file excel with many sheets, more than 10. with the same column and header. Now i want to create master sheet by combining all sheet become one.
Actually i can manually use copy-paste but the problem if i should edit/update one of sheet i should update to master sheet.
using macro, how to create master sheet and if there are a changed in one or more sheet, the master sheet will change automatically.

thanks for ur kind : pray2:

reza

[Aussiebear]

have a look at the following:

www.vbaexpress.com/kb/getarticle.php?kb_id=773

[reza_doang]

have a look at the following:

www.vbaexpress.com/kb/getarticle.php?kb_id=773 (http://www.vbaexpress.com/kb/getarticle.php?kb_id=773)

aussiebear...

i already try but failed, maybe i didn't change my path. and i don't how to change it.
1. my file name is "Rencana Verifikasi 2010.xlsx"
2. path file "D:\02. Work\Komersil\052010"
3. i only have 1 file but have 13 sheets that i want to combine...

sorry i can't send attachment because classified.

thanks