multiple workbooks

[Pamela]

hopefully someone will be able to point me in the right
direction -

we have a series of 51 workbooks we use to track
departmental information. We have a master table that
contains information for all the workbooks and each month
a team opens the table and cuts & pastes the necessary
information to each of the 51 workbooks. There has to be
an easier way to do this. Is it as simple as linking all
the workbooks back to the master table? Or is there a
better way to do it?

Any help would be greatly appreciated.

 

[Ray]

You should just link to all. It will be time consuming to
set up but once done....

 

[Ron de Bruin]

Try this example Pamela
http://www.rondebruin.nl/copy4.htm