referring a worksheet

Hi everybody,

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

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



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


--
lazmanyakPosted from http://www.pcreview.co.uk/ newsgroup access

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

"lazmanyak" wrote:

>
> Hi everybody,
>
> I want to copy a worksheet to another file(or worksheet).
> when i change something in the original worksheet every changes will
> take place in the other one.
> it is something to refer to a cell. but i want to refer to whole
> worksheet.
>
> I have more than a fifty workbooks. I want to copy all of them into a
> new workbook in different sheets.this workbook will contain all my
> excel documents in one workbook but in different sheets. however when i
> change something in the original files every change should take place in
> the new workbook.
>
>
>
> how can i do this in excel?
> many thanks in advance.....
>
>
> --
> lazmanyakPosted from http://www.pcreview.co.uk/ newsgroup access
>
>