software

I am trying to create a linked copy of a marketing grid that can be used
within my production group for our personal status report. The goal is to
have ONE grid (i.e. the status report) where we can keep track of the
specifics of all of our projects, and that this grid will automatically
receive updates on those projects from the source documents. The copied grid
(let's call this B) should have all the fields of the source grid (let's call
this A), but should allow for additional material to be added and maintained.

I have experimented with this for quite some time, and have even taken a
course in Excel, which didn't answer my questions. Here are the problems
that I am running into.

-Grid A is too large to copy ALL information (range is from 0-600, A-U...and
is added to and taken from weekly)

-when information is added to grid A outside of originally set range, this
information is not automatically updated on grid B

-when order of information is changed in grid B, this breaks the link...I
assume we cannot change orderThese are my questions:

-Do I have to do this linking between (2) worksheets in a workbook, or can
the process work between separate workbooks?

-How can I link ALL cells from one worksheet to another, and not simply
within a certain range, to allow for all additions to transfer to grid B?

-Can I add columns to grid B that will not appear, nor be effected by grid A?

-Can I move information around within grid B?

I will be happy to elaborate if any of this is unclear. I appreciate any
and all suggestions.

Thanks,
Kirstin