referring a worksheet

[lazmanyak]

Hi everybody,

I want to copy a worksheet to another file(or worksheet).
when i change something in the original worksheet every changes wil
take place in the other one.
it is something to refer to a cell. but i want to refer to whol
worksheet.

I have more than a fifty workbooks. I want to copy all of them into
new workbook in different sheets.this workbook will contain all m
excel documents in one workbook but in different sheets. however when
change something in the original files every change should take place i
the new workbook.



how can i do this in excel?
many thanks in advance....

 

[tired of finding my data scrambled]

do the first link in the new workbook then just copy and paste down until it
matches