How to create a master sheet of several (12 maybe more) worksheets

[Saad]

HI
How do i create a master sheet of several (12 maybe more) worksheets that
are in the same work book and in a manner that if i make changes in the
mastersheet, it also changes the other sheet.

I have to do this with several files in excel and than create a master file
of all the master files.(i.e. if i have with your help of course made 12
different excel files each having an master file and then i have to create a
single master file of all the mastersheets in the 12 workbooks)

About the data in the worksheets:

*Data has a header row
*Some entries might be repeated but i dont want to lose the repeated data.

"I have tried to use paste link from paste special but it takes to much time
and than microsoft excel 2003 hangs" Any idea's how i can achieve this.

I hope given information is enough, if not let me know.
Thanks in advance.

 

[Eduardo]

Hi,
look into Ron web he has a macro

http://www.rondebruin.nl/copy2.htm

if this helps please click yes thanks